IMPORT_REJECTION 
Default Table Name  IMPORT_REJECTION 
Definition 
 Name: Timesheet Rejections.     Description: This staging table contains timesheet rejections that will be imported to Deltek Time and Expense if validations are passed.
 

IMPORT_REJECTION Columns 
ColumnName  Domain  Datatype  NULL  Definition 
USER_COMPANY_ID    VARCHAR2(30)  NO 
Name: Domain. Description: Alias for database schema that will be updated.
 
S_IMPORT_CD    VARCHAR2(1)  NO 
Name: Import Type. Description: Indicates the type of transaction. The valid values are:C - Update . 
 
TIME_STAMP    DATE  NO 
Name: Time Stamp. Description: A time/date stamp that indicates when the record was originally inserted into table.
 
EXTERNAL_USER    VARCHAR2(20)  NO 
Name: External User. Description: User ID of the non-TC user initiating the insert into the Import table. 
 
S_REJECT_TYPE_CD    VARCHAR2(1)  NO 
Name: Reject Type. Description: Indicates the type of record being imported. The valid values are:T - Timesheet. L - Line. C - Cell. 
 
BATCH_ID    VARCHAR2(10)  NO 
Name: Batch ID. Description: The ID of the batch to which the rejection belongs.
 
EMPL_ID    VARCHAR2(20)  NO 
Name: Employee ID. Description: Employee ID identifier.
 
TS_SCHEDULE_CD    VARCHAR2(10)  NO 
Name: Timesheet Schedule. Description: Timesheet frequency identifier.
 
YEAR_NO_CD    VARCHAR2(4)  NO 
 
PERIOD_NO_CD    VARCHAR2(3)  NO 
Name: Timesheet Period. Description: Period number for timesheet frequency.
 
LINE_NO    NUMBER(10, 0)  YES 
Name: Timesheet Line. Description: The timesheet line number to which this rejection belongs.
 
HRS_DT    DATE  YES 
Name: Hours Date. Description: The column date to which this rejection belongs.
 
S_CELL_STATUS_CD    VARCHAR2(1)  NO 
Name: Timesheet Cell Status. Description: The status that should be set for lines and cells. The valid values are:R - Reject. O - Open
 
REJECTION_TEXT    VARCHAR2(254)  YES 
Name: Rejected Reason. Description: The reason for the rejection.
 

IMPORT_REJECTION Primary and Unique Keys 
Key Name  Key Type  Keys 

IMPORT_REJECTION 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