TEMP_EXP_RPT 
Default Table Name  TEMP_EXP_RPT 
Definition 
 Name: Temporary Expense Report.     Description: This table contains the summary information for an expense report. 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_RPT Columns 
ColumnName  Domain  Datatype  NULL  Definition 
EXP_RPT_ID    VARCHAR2(10)  YES 
Name: Expense Report ID. Description: The unique identifier for the expense report.
 
EMPL_ID    VARCHAR2(20)  YES 
Name: Employee ID. Description: The employee whose export it is.
 
EXP_RPT_DESC    VARCHAR2(30)  YES 
Name: Expense Report Description. Description: Short description of the expense report.
 
EXP_RPT_DT    DATE  YES 
Name: Expense Report Date. Description: User assigned date for expense report.
 
REVISION_NO    NUMBER(10, 0)  YES 
Name: Revision Number. Description: The current revision of the expense report.
 
S_EXP_RPT_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
 
S_RECEIPT_STATUS_CD    VARCHAR2(1)  YES 
Name: Receipt Status. Description: The valid values are: P – Pending. R – Received. N – Not Applicable
 
START_DT    DATE  YES 
Name: Start Date. Description: Starting date of expenses. This mainly for trip type expenses.
 
END_DT    DATE  YES 
Name: End Date. Description: Starting date of expenses. This mainly for trip type expenses. 
 
PURPOSE_TEXT    VARCHAR2(4000)  YES 
Name: Purpose. Description: The purpose of the expenses on the report.
 
PER_DIEM_SCHEDULE_CD    VARCHAR2(10)  YES 
Name: Per Diem Schedule. Description: The per diem schedule that applies to the expense report.
 
CURRENCY_SCHEDULE_CD    VARCHAR2(10)  YES 
Name: Currency Schedule. Description: The currency schedule that applies to the expense report.
 
EXP_RPT_TYPE_CD    VARCHAR2(10)  YES 
Name: Expense Report Type. Description: The type of expense report.
 
EXP_CLASS_CD    VARCHAR2(20)  YES 
Name: Expense Class. Description: The expense class of the employee at the time of the expense report.
 
UNAVAILABLE_FL    VARCHAR2(1)  YES 
Name: Unavailable Flag. Description: Logical as to whether this expense report is unavailable.
 
BATCH_ID    VARCHAR2(10)  YES 
Name: Batch ID. Description: The ID of the process that currently has the expense report unavailable
 
CP_COMPANY_CD    VARCHAR2(10)  YES 
Name: Costpoint Company. Description: Costpoint Company Code of expense report. (Employee)
 
SUBMIT_WARNING_TEXT    VARCHAR2(1000)  YES 
Name: Sign Warnings. Description: Warnings received during last expense report 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. 
 
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.
 
EXP_RPT_UDT_ID    VARCHAR2(50)  YES 
Name: Expense Report Header UDT Option. Description: The configured UDT that is displayed in header.
 
S_IMAGE_STATUS_CD    VARCHAR2(1)  YES 
Name: Receipt Image Status. Description: The system assigned image status code. The valid values are: P – Pending. R – Received. N – Not Applicable
 
EXP_AUTH_ID    VARCHAR2(10)  YES 
Name: Expene Authorization ID. Description: The Expense Authorization for this expense report. 
 
RECEIVABLE_UDT01_ID    VARCHAR2(50)  YES 
Name: Receivable UDT01 ID. Description: The UDT01 identifier for the employee receivable charge.
 
RECEIVABLE_UDT02_ID    VARCHAR2(50)  YES 
Name: Receivable UDT02 ID. Description: The UDT02 identifier for the employee receivable charge.
 
RECEIVABLE_UDT03_ID    VARCHAR2(20)  YES 
Name: Receivable UDT03 ID. Description: The UDT03 identifier for the employee receivable charge.
 
RECEIVABLE_UDT04_ID    VARCHAR2(20)  YES 
Name: Receivable UDT04 ID. Description: The UDT04 identifier for the employee receivable charge.
 
RECEIVABLE_UDT05_ID    VARCHAR2(20)  YES 
Name: Receivable UDT05 ID. Description: The UDT05 identifier for the employee receivable charge.
 
RECEIVABLE_UDT06_ID    VARCHAR2(20)  YES 
Name: Receivable UDT06 ID. Description: The UDT06 identifier for the employee receivable charge.
 
RECEIVABLE_UDT07_ID    VARCHAR2(20)  YES 
Name: Receivable UDT07 ID. Description: The UDT07 identifier for the employee receivable charge.
 
RECEIVABLE_UDT08_ID    VARCHAR2(20)  YES 
Name: Receivable UDT08 ID. Description: The UDT08 identifier for the employee receivable charge.
 
RECEIVABLE_UDT09_ID    VARCHAR2(20)  YES 
Name: Receivable UDT09 ID. Description: The UDT09 identifier for the employee receivable charge.
 
RECEIVABLE_UDT10_ID    VARCHAR2(20)  YES 
Name: Receivable UDT10 ID. Description: The UDT10 identifier for the employee receivable charge.
 
RECEIVABLE_UDT06_CP_COMPANY_CD    VARCHAR2(10)  YES 
Name: Receivable UDT06 Costpoint Company. Description: Costpoint Company Code for employee receivable UDT06_ID field.
 
RECEIVABLE_UDT07_CP_COMPANY_CD    VARCHAR2(10)  YES 
Name: Receivable UDT07 Costpoint Company. Description: Costpoint Company Code for employee receivable UDT07_ID field.
 
RECEIVABLE_EXPENSE_REF_CD    VARCHAR2(20)  YES 
Name: Receivable Reference Code. Description: User defined reference code for employee receivable charge.
 
PAY_RECEIVABLE_AMT    NUMBER(15, 5)  YES 
Name: Pay Currency Receivable Amount. Description: The employee receivable amount. This amount is in the employee’s pay currency.
 
BASE_RECEIVABLE_AMT    NUMBER(15, 5)  YES 
Name: Base Currency Receivable Amount. Description: The employee receivable amount. This amount is in the system’s base currency.
 
S_DUE_COMPANY_PAYMENT_CD    VARCHAR2(10)  YES 
Name: Due Company Payment Option. Description: Indicates the method of payment the employee indicated for net due company expense reports. The valid values are as follows: NONE - None. CASH – Cash. CHECK – Check. DEDUCTION – Payroll Deduction. OTHER – Other
 
DUE_COMPANY_REFERENCE_S    VARCHAR2(20)  YES 
Name: Due Company Payment Reference. Description: Text field where employee can provide details if payment is check or other.
 
PAYMENT_UDT01_ID    VARCHAR2(50)  YES 
Name: Payment UDT01 ID. Description: The UDT01 identifier for the payment.
 
PAYMENT_UDT02_ID    VARCHAR2(50)  YES 
Name: Payment UDT02 ID. Description: The UDT02 identifier for the payment.
 
PAYMENT_UDT03_ID    VARCHAR2(20)  YES 
Name: Payment UDT03 ID. Description: The UDT03 identifier for the payment.
 
PAYMENT_UDT04_ID    VARCHAR2(20)  YES 
Name: Payment UDT04 ID. Description: The UDT04 identifier for the payment.
 
PAYMENT_UDT05_ID    VARCHAR2(20)  YES 
Name: Payment UDT05 ID. Description: The UDT05 identifier for the payment.
 
PAYMENT_UDT06_ID    VARCHAR2(20)  YES 
Name: Payment UDT06 ID. Description: The UDT06 identifier for the payment.
 
PAYMENT_UDT07_ID    VARCHAR2(20)  YES 
Name: Payment UDT07 ID. Description: The UDT07 identifier for the payment.
 
PAYMENT_UDT08_ID    VARCHAR2(20)  YES 
Name: Payment UDT08 ID. Description: The UDT08 identifier for the payment.
 
PAYMENT_UDT09_ID    VARCHAR2(20)  YES 
Name: Payment UDT09 ID. Description: The UDT09 identifier for the payment.
 
PAYMENT_UDT10_ID    VARCHAR2(20)  YES 
Name: Payment UDT10 ID. Description: The UDT10 identifier for the payment.
 
PAYMENT_UDT06_CP_COMPANY_CD    VARCHAR2(10)  YES 
Name: Payment UDT06 Costpoint Company. Description: Costpoint Company Code for UDT06_ID field for the payment.
 
PAYMENT_UDT07_CP_COMPANY_CD    VARCHAR2(10)  YES 
Name: Payment UDT07 Costpoint Company. Description: Costpoint Company Code for UDT07_ID field for the payment.
 
PAYMENT_EXPENSE_REF_CD    VARCHAR2(20)  YES 
Name: Payment Reference Code. Description: User defined reference code for the payment.
 
FIRST_DAY_TRIP_FL    VARCHAR2(1)  YES 
Name: First Day Trip Flag. Description: Logical as to whether this expense report contains the first day of the trip.
 
LAST_DAY_TRIP_FL    VARCHAR2(1)  YES 
Name: Last Day Trip Flag. Description: Logical as to whether this expense report contains the last day of the trip.
 
CODE1_CD    VARCHAR2(20)  YES 
Name: User Defined Code 1. Description: The Code1 user defined field. The values are based on the expense report type.
 
CODE2_CD    VARCHAR2(20)  YES 
Name: User Defined Code 2. Description: The Code2 user defined field. The values are based on the expense report type.
 
CODE3_CD    VARCHAR2(20)  YES 
Name: User Defined Code 3. Description: The Code3 user defined field. The values are based on the expense report type.
 
RECEIVABLE_UDT11_ID    VARCHAR2(20)  YES 
Name: Receivable UDT11 ID. Description: The UDT11 identifier for the Receivable line.
 
RECEIVABLE_UDT12_ID    VARCHAR2(20)  YES 
Name: Receivable UDT12 ID. Description: The UDT12 identifier for the Receivable line.
 
RECEIVABLE_UDT13_ID    VARCHAR2(20)  YES 
Name: Receivable UDT13 ID. Description: The UDT13 identifier for the Receivable line.
 
RECEIVABLE_UDT14_ID    VARCHAR2(20)  YES 
Name: Receivable UDT14 ID. Description: The UDT14 identifier for the Receivable line.
 
RECEIVABLE_UDT15_ID    VARCHAR2(20)  YES 
Name: Receivable UDT15 ID. Description: The UDT15 identifier for the Receivable line.
 
PAYMENT_UDT11_ID    VARCHAR2(20)  YES 
Name: Payment UDT11 ID. Description: The UDT11 identifier for the payment.
 
PAYMENT_UDT12_ID    VARCHAR2(20)  YES 
Name: Payment UDT12 ID. Description: The UDT12 identifier for the payment.
 
PAYMENT_UDT13_ID    VARCHAR2(20)  YES 
Name: Payment UDT13 ID. Description: The UDT13 identifier for the payment.
 
PAYMENT_UDT14_ID    VARCHAR2(20)  YES 
Name: Payment UDT14 ID. Description: The UDT14 identifier for the payment.
 
PAYMENT_UDT15_ID    VARCHAR2(20)  YES 
Name: Payment UDT15 ID. Description: The UDT15 identifier for the payment.
 
SHORT_HEADER_TEXT    VARCHAR2(4000)  YES 
Name: Expense Report Notes. Description: Administrative notes pertaining to the entire expense report.
 
CORRECTION_NO    NUMBER(10, 0)  YES 
Name: Correction Number. Description: The current correction number of the expense report.
 

TEMP_EXP_RPT Primary and Unique Keys 
Key Name  Key Type  Keys 

TEMP_EXP_RPT 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