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 Attributes 
Attribute/Logical Rolename  Domain  Datatype  NULL  Definition 
EMPL_ID    VARCHAR(20)  YES 
Name: Employee ID. Description: Employee ID identifier.
 
TS_SCHEDULE_CD    VARCHAR(10)  YES 
Name: Timesheet Schedule. Description: Timesheet frequency identifier.
 
YEAR_NO_CD    VARCHAR(4)  YES 
 
PERIOD_NO_CD    VARCHAR(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    NUMERIC(10, 0)  YES 
Name: Sequence Number. Description: Sequence number to allow unique key
 
S_START_STOP_TYPE_CD    VARCHAR(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    NUMERIC(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    VARCHAR(254)  YES 
Name: Comments. Description: User-provided comments for start/stop time.
 
MODIFIED_BY    VARCHAR(20)  YES 
 
ROWVERSION    NUMERIC(10, 0)  YES 
 
TIME_STAMP    DATE  YES 
 

TEMP_TS_START_STOP Keys 
Key Name  Key Type  Keys 

TEMP_TS_START_STOP 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