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 Attributes 
Attribute/Logical Rolename  Domain  Datatype  NULL  Definition 
USER_COMPANY_ID    VARCHAR(30)  NO 
Name: Domain. Description: Alias for database schema that will be updated.
 
S_IMPORT_CD    VARCHAR(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    VARCHAR(20)  NO 
Name: External User. Description: User ID of the non-TC user initiating the insert into the Import table. 
 
S_REJECT_TYPE_CD    VARCHAR(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    VARCHAR(10)  NO 
Name: Batch ID. Description: The ID of the batch to which the rejection belongs.
 
EMPL_ID    VARCHAR(20)  NO 
Name: Employee ID. Description: Employee ID identifier.
 
TS_SCHEDULE_CD    VARCHAR(10)  NO 
Name: Timesheet Schedule. Description: Timesheet frequency identifier.
 
YEAR_NO_CD    VARCHAR(4)  NO 
 
PERIOD_NO_CD    VARCHAR(3)  NO 
Name: Timesheet Period. Description: Period number for timesheet frequency.
 
LINE_NO    NUMERIC(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    VARCHAR(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    VARCHAR(254)  YES 
Name: Rejected Reason. Description: The reason for the rejection.
 

IMPORT_REJECTION Keys 
Key Name  Key Type  Keys 
SI_0030  Inversion Entry  USER_COMPANY_ID, S_IMPORT_CD, TIME_STAMP, EXTERNAL_USER, S_REJECT_TYPE_CD, BATCH_ID, EMPL_ID, TS_SCHEDULE_CD, YEAR_NO_CD, PERIOD_NO_CD, LINE_NO, HRS_DT 

IMPORT_REJECTION Relationships 
Parent Relationships: 
Entity Name  Type  Cardinality  Business Name  VerbPhrase  InversePhrase  Foreign Keys  Is Supertype 
Child Relationships: 
Entity Name  Type  Cardinality  Business Name  VerbPhrase  InversePhrase  Foreign Keys  Is Subtype