EXP_AUTH 
Default Table Name  EXP_AUTH 
Definition 
 Name: Expense Authorization .     Description: This table contains the overall information about specific expense authorization.
 

EXP_AUTH Attributes 
Attribute/Logical Rolename  Domain  Datatype  NULL  Definition 
EXP_AUTH_ID(PK)    VARCHAR(10)  NO 
Name: Expense Authorization ID. Description: The unique identifier for the expense authorization.
 
EMPL_ID(FK)    VARCHAR(20)  NO 
Name: Employee ID. Description: The employee whose expense authorization it is.
 
EXP_AUTH_DESC    VARCHAR(30)  NO 
Name: Expense Authorization Description. Description: Short description of the expense authorization.
 
EXP_AUTH_DT    DATE  NO 
Name: Expense Authorization Date. Description: User assigned date for expense authorization.
 
REVISION_NO    NUMERIC(10, 0)  NO 
Name: Revision Number. Description: The current revision of the expense authorization.
 
S_EXP_AUTH_STATUS_CD    VARCHAR(1)  NO 
Name: Expense Report Status. Description: The valid values are:D - Draft. S – Submitted. U – Under Review. A – Approved. R – Rejected. P – Processed. V – Voided. 
 
START_DT    DATE  NO 
Name: Start Date. Description: Starting date of expenses. This mainly for trip type expense authorizations.
 
END_DT    DATE  NO 
Name: End Date. Description: Starting date of expenses. This mainly for trip type expense authorizations. 
 
PURPOSE_TEXT    VARCHAR(4000)  YES 
Name: Purpose. Description: The purpose of the expense authorization.
 
PER_DIEM_SCHEDULE_CD(FK)    VARCHAR(10)  YES 
Name: Per Diem Schedule. Description: The per diem schedule that applies to the expense authorization.
 
CURRENCY_SCHEDULE_CD(FK)    VARCHAR(10)  YES 
Name: Currency Schedule. Description: The currency schedule that applies to the expense authorization.
 
EXP_RPT_TYPE_CD(FK)    VARCHAR(10)  NO 
Name: Expense Report Type. Description: The type of expense report for this expense authorization.
 
EXP_CLASS_CD(FK)    VARCHAR(20)  NO 
Name: Expense Class. Description: The expense class of the employee at the time of the expense authorization.
 
CP_COMPANY_CD(FK)    VARCHAR(10)  NO 
Name: Costpoint Company Code. Description: Costpoint Company Code of expense authorization. (Employee)
 
SUBMIT_WARNING_TEXT    VARCHAR(1000)  YES 
Name: Sign Warnings. Description: Warnings received during last expense authorization submit.
 
PAY_CURRENCY_CD(FK)    VARCHAR(3)  NO 
Name: Pay Currency. Description: The currency code of that the employee will be reimbursed in.
 
BASE_CURRENCY_CD(FK)    VARCHAR(3)  NO 
Name: Base Currency. Description: The base currency code of the system. 
 
EXP_AUTH_UDT_ID    VARCHAR(50)  YES 
Name: Expense Authorization Header Charge. Description: The configured UDT that is displayed in header.
 
MODIFIED_BY    VARCHAR(20)  NO 
Name: Modified By. Description: The User ID of the person who last modified this record.
 
ROWVERSION    NUMERIC(10, 0)  NO 
Name: Row Version. Description: The number of times this record has been updated.
 
TIME_STAMP    DATE  NO 
Name: Time Stamp. Description: Date and time the record was last modified.
 
COPIED_AUTH_FL    VARCHAR(1)  NO 
Name: Copied Authorization Flag. Description: Logical as to whether this authorization was copied from another authorization. 
 
FIRST_DAY_TRIP_FL    VARCHAR(1)  NO 
Name: First Day Flag. Description: Logical as to whether this expense authorization contains the first day of the trip.
 
LAST_DAY_TRIP_FL    VARCHAR(1)  NO 
Name: Last Day Flag. Description: Logical as to whether this expense authorization contains the last day of the trip.
 
SHORT_HEADER_TEXT    VARCHAR(4000)  YES 
Name: Notes. Description: Administrative notes pertaining to the entire expense authroization.
 
BLANKET_AUTH_FL    VARCHAR(1)  NO 
Name: Blanket Authorization Flag. Description: Indicates whether this type of expense report allows blanket authorizations
 
BLANKET_CLOSED_FL    VARCHAR(1)  NO 
Name: Blanket Authorization Closed Flag. Description: Indicates whether the blanket authorization is closed.
 

EXP_AUTH Keys 
Key Name  Key Type  Keys 
RI_F00354  Inversion Entry  PER_DIEM_SCHEDULE_CD 
RI_F00353  Inversion Entry  EXP_RPT_TYPE_CD 
RI_F00352  Inversion Entry  EXP_CLASS_CD 
RI_F00351  Inversion Entry  EMPL_ID 
RI_F00350  Inversion Entry  CURRENCY_SCHEDULE_CD 
RI_F00349  Inversion Entry  BASE_CURRENCY_CD 
RI_F00348  Inversion Entry  PAY_CURRENCY_CD 
RI_F00347  Inversion Entry  CP_COMPANY_CD 
PI_0240  PrimaryKey  EXP_AUTH_ID 

EXP_AUTH Relationships 
Parent Relationships: 
Entity Name  Type  Cardinality  Business Name  VerbPhrase  InversePhrase  Foreign Keys  Is Supertype 
CP_COMPANY  Non-Identifying  One To Zero or More        CP_COMPANY_CD  NO 
CURRENCY  Non-Identifying  One To Zero or More        PAY_CURRENCY_CD  NO 
CURRENCY  Non-Identifying  One To Zero or More        BASE_CURRENCY_CD  NO 
CURRENCY_SCHEDULE  Non-Identifying  Zero or One to Zero or More        CURRENCY_SCHEDULE_CD  NO 
EMPL  Non-Identifying  One To Zero or More        EMPL_ID  NO 
EXP_CLASS  Non-Identifying  One To Zero or More        EXP_CLASS_CD  NO 
EXP_RPT_TYPE  Non-Identifying  One To Zero or More        EXP_RPT_TYPE_CD  NO 
PER_DIEM  Non-Identifying  Zero or One to Zero or More        PER_DIEM_SCHEDULE_CD  NO 
Child Relationships: 
Entity Name  Type  Cardinality  Business Name  VerbPhrase  InversePhrase  Foreign Keys  Is Subtype 
EXP_RPT  Non-Identifying  One To Zero or More          NO 
EXP_AUTH_CHARGE_ALLOCATIONS  Identifying  One To Zero or More          NO 
EXP_AUTH_EXPENSE  Identifying  One To Zero or More          NO 
EXP_AUTH_REVISION  Identifying  One To Zero or More          NO 
DESKTOP_AUTH_TASKS  Identifying  One To Zero or More          NO 
ADVANCE_OUTSTANDING  Non-Identifying  One To Zero or More          NO 
EXP_AUTH_LOCATION  Identifying  One To Zero or More          NO 
EXP_ADVANCE  Non-Identifying  One To Zero or More          NO 
TASK  Non-Identifying  Zero or One to Zero or More          NO 
CORRECT_TASK  Non-Identifying  One To Zero or More          NO 
EXP_AUTH_WARNING  Identifying  One To Zero or More          NO