TEMP_TS_START_STOP 
Default Table Name  TEMP_TS_START_STOP 
Definition 
 Name: Temporary Timesheet Start/Stop Times.     Description: This table contains the timesheet start and stop times for the pre-save stored procedure validations.
 

TEMP_TS_START_STOP Columns 
ColumnName  Domain  Datatype  NULL  Definition 
EMPL_ID    VARCHAR2(20)  YES 
Name: Employee ID. Description: Employee ID identifier.
 
TS_SCHEDULE_CD    VARCHAR2(10)  YES 
Name: Timesheet Schedule. Description: Timesheet frequency identifier.
 
YEAR_NO_CD    VARCHAR2(4)  YES 
 
PERIOD_NO_CD    VARCHAR2(3)  YES 
Name: Period Number. Description: Period number for timesheet frequency.
 
COLUMN_DT    DATE  YES 
Name: Date. Description: The date for this timesheet column.
 
SEQ_NO    NUMBER(10, 0)  YES 
Name: Sequence Number. Description: Sequence number to allow unique key
 
S_START_STOP_TYPE_CD    VARCHAR2(1)  YES 
Name: Start/Stop Time Type. Description: Indicates the type of start/stop time it is. The valid values are C – Charge. B – Break. L – Lunch. W - Work
 
LINE_NO    NUMBER(10, 0)  YES 
Name: Line Number. Description: The timesheet line number if start/stop time is for a charge.
 
START_DTT    DATE  YES 
Name: Start Date/Time. Description: The start date/time for the record.
 
STOP_DTT    DATE  YES 
Name: Stop Date/Time. Description: The stop date/time for the record.
 
START_STOP_TEXT    VARCHAR2(254)  YES 
Name: Comments. Description: User-provided comments for start/stop time.
 
MODIFIED_BY    VARCHAR2(20)  YES 
 
ROWVERSION    NUMBER(10, 0)  YES 
 
TIME_STAMP    DATE  YES 
 

TEMP_TS_START_STOP Primary and Unique Keys 
Key Name  Key Type  Keys 

TEMP_TS_START_STOP 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