TEMP_EXP_AUTH 
Default Table Name  TEMP_EXP_AUTH 
Definition 
 Name: Temporary Expense Authorization.  Description: This table contains the summary information for an expense authorization. This is a temporary table that is populated pre-save for use with pre-save stored procedure. Table shall never have any permanent data.
 

TEMP_EXP_AUTH Columns 
ColumnName  Domain  Datatype  NULL  Definition 
EXP_AUTH_ID    VARCHAR2(10)  YES 
Name: Expense Authorization ID. Description: The unique identifier for the expense .
 
EMPL_ID    VARCHAR2(20)  YES 
Name: Employee ID. Description: The employee whose expense authorization it is.
 
EXP_AUTH_DESC    VARCHAR2(30)  YES 
Name: Expense Authorization Description. Description: Short description of the expense authorization.
 
EXP_AUTH_DT    DATE  YES 
Name: Expense Authorization Date. Description: User assigned date for expense authorization.
 
REVISION_NO    NUMBER(10, 0)  YES 
Name: Revision Number. Description: The current revision of the expense authorization.
 
S_EXP_AUTH_STATUS_CD    VARCHAR2(1)  YES 
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  YES 
Name: Start Date. Description: Starting date of expenses. This mainly for trip type expense authorizations.
 
END_DT    DATE  YES 
Name: End Date. Description: Ending date of expenses. This mainly for trip type expense authorizations.
 
PURPOSE_TEXT    VARCHAR2(4000)  YES 
Name: Purpose. Description: The purpose of the expense authorization.
 
PER_DIEM_SCHEDULE_CD    VARCHAR2(10)  YES 
Name: Per Diem Schedule. Description: The per diem schedule that applies to the expense authorization.
 
CURRENCY_SCHEDULE_CD    VARCHAR2(10)  YES 
Name: Currency Schedule. Description: The currency schedule that applies to the expense authorization.
 
EXP_RPT_TYPE_CD    VARCHAR2(10)  YES 
Name: Expense Report Type. Description: The type of expense report for this expense authorization.
 
EXP_CLASS_CD    VARCHAR2(20)  YES 
Name: Expense Class. Description: The expense class of the employee at the time of the expense authorization.
 
CP_COMPANY_CD    VARCHAR2(10)  YES 
Name: Costpoint Company Code. Description: Costpoint Company Code of expense authorization.
 
SUBMIT_WARNING_TEXT    VARCHAR2(1000)  YES 
Name: Sign Warnings. Description: Warnings received during last expense authorization submit.
 
PAY_CURRENCY_CD    VARCHAR2(3)  YES 
Name: Pay Currency. Description: The currency code of that the employee will be reimbursed in.
 
BASE_CURRENCY_CD    VARCHAR2(3)  YES 
Name: Base Currency. Description: The base currency code of the system.
 
EXP_AUTH_UDT_ID    VARCHAR2(50)  YES 
Name: Expense Authorization Header Charge. Description: The configured UDT that is displayed in header.
 
MODIFIED_BY    VARCHAR2(20)  YES 
Name: Modified By. Description: The User ID of the person who last modified this record.
 
ROWVERSION    NUMBER(10, 0)  YES 
Name: Row Version. Description: The number of times this record has been updated.
 
TIME_STAMP    DATE  YES 
Name: Time Stamp. Description: Date and time the record was last modified.
 
COPIED_AUTH_FL    VARCHAR2(1)  YES 
Name: Copied Authorization Flag. Description: Logical as to whether this authorization was copied from another authorization.
 
FIRST_DAY_TRIP_FL    VARCHAR2(1)  YES 
Name: First Day Flag. Description: Logical as to whether this expense authorization contains the first day of the trip.
 
LAST_DAY_TRIP_FL    VARCHAR2(1)  YES 
Name: Last Day Flag. Description: Logical as to whether this expense authorization contains the last day of the trip.
 
SHORT_HEADER_TEXT    VARCHAR2(4000)  YES 
Name: Notes. Description: Administrative notes pertaining to the entire expense authroization.
 
BLANKET_AUTH_FL    VARCHAR2(1)  YES 
Name: Blanket Authorization Flag. Description: Indicates whether this type of expense report allows blanket authorizations.
 
BLANKET_CLOSED_FL    VARCHAR2(1)  YES 
Name: Blanket Authorization Closed Flag. Description: Indicates whether the blanket authorization is closed.
 

TEMP_EXP_AUTH Primary and Unique Keys 
Key Name  Key Type  Keys 

TEMP_EXP_AUTH Foreign Keys 
Parent Relationships: 
Table Name  Type  Cardinality  Constraint Name  VerbPhrase  InversePhrase  Foreign Keys  Is Supertype  Deferrable 
Child Relationships: 
Table Name  Type  Cardinality  Constraint Name  VerbPhrase  InversePhrase  Foreign Keys  Is Subtype  Deferrable