EXP_RPT_TYPE_SCHEDULE 
Default Table Name  EXP_RPT_TYPE_SCHEDULE 
Definition 
 Name: Expense Report Type Schedules.     Description: This table controls the order of supporting schedules for expense reports and expense authorizations.
 

EXP_RPT_TYPE_SCHEDULE Attributes 
Attribute/Logical Rolename  Domain  Datatype  NULL  Definition 
EXP_RPT_TYPE_CD(PK)(FK)    VARCHAR(10)  NO 
Name: Expense Report Type. Description: The unique identifier for the expense report type
 
S_TYPE_CD(PK)    VARCHAR(2)  NO 
Name: Type. Description: Indicates whether schedule is expense reports or expense authorizations. The valid values are as follows: ER – Expense Report. EA – Expense Auth
 
S_SCHEDULE_CD(PK)    VARCHAR(10)  NO 
Name: Supporting Schedule. Description: The identifier for the schedule. The valid values are EASTAT – Expense Authorization Status Schedule. EACASH – Expense Authorization Cash Advance Schedule. EAREV – Expense Authorization Revision Schedule. EACHRG – Expense Authorization Charge Allocation Schedule. ERCASH – Expense Report Cash Advance Schedule. ERBILL – Expense Report Billable Schedule. ERCHRG – Expense Report Charge Allocation Schedule. ERCOPD – Expense Report Company Paid Schedule. ERLABOR – Expense Report Labor Supporting Schedule. ERNOREIM – Expense Report Non Reimbursable Schedule. EROVERCEIL – Expense Report Over Ceiling Schedule. ERPAY – Expense Report Payments Schedule. ERPERSON – Expense Report Personal Schedule. ERRECEIPT – Expense Report Receipt Schedule. ERSTAT – Expense Report Status Schedule. ERREV – Expense Report Revisions Schedule. ERVOUCH – Expense Report Voucher Distribution Schedule. ERUNALLOW – Expense Report Unallowable Schedule
 
FIELD_LABEL_CD    VARCHAR(7)  NO 
Name: Message Bundle Label. Description: The message bundle label code for the record.
 
ORDER_NO    NUMERIC(10, 0)  NO 
Name: Schedule Order. Description: The order in which the scheduled shall be shown. An order of 0 means that schedule shall not be displayed. 
 
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.
 

EXP_RPT_TYPE_SCHEDULE Keys 
Key Name  Key Type  Keys 
RI_F00391  Inversion Entry  EXP_RPT_TYPE_CD 
PI_0257  PrimaryKey  EXP_RPT_TYPE_CD, S_TYPE_CD, S_SCHEDULE_CD 

EXP_RPT_TYPE_SCHEDULE Relationships 
Parent Relationships: 
Entity Name  Type  Cardinality  Business Name  VerbPhrase  InversePhrase  Foreign Keys  Is Supertype 
EXP_RPT_TYPE  Identifying  One To Zero or More        EXP_RPT_TYPE_CD  NO 
Child Relationships: 
Entity Name  Type  Cardinality  Business Name  VerbPhrase  InversePhrase  Foreign Keys  Is Subtype