EMPL_ID 
ColumnName  EMPL_ID 
Definition 
Name: Employee ID. Description: Unique identifier for the employee.
 

LEAVE_TYPE_CD 
ColumnName  LEAVE_TYPE_CD 
Definition 
Name: Leave Type. Description: Unique identifier for the type of leave.
 

TRANS_DT 
ColumnName  TRANS_DT 
Definition 
Name: Transaction Date. Description: Date of Transaction.
 

S_TRANS_TYPE_CD 
ColumnName  S_TRANS_TYPE_CD 
Definition 
Name: Transaction Type. Description: The type of transaction. Valid options are as follows: BEG - Beginning Balance. . TAKEN - Taken. ADJUSTMENT - Adjustment. 
 

TS_SCHEDULE_CD 
ColumnName  TS_SCHEDULE_CD 
Definition 
Name: Timesheet Schedule. Description: If S_TRANS_TYPE_CD is "TAKEN," this value will identify the specific timesheet on which the leave was taken. If S_TRANS_TYPE_CD is not "TAKEN," this value is "N/A." 
 

YEAR_NO_CD 
ColumnName  YEAR_NO_CD 
Definition 
Name: Timesheet Year. Description: If S_TRANS_TYPE_CD is "TAKEN," this value will identify the year of the timesheet on which the leave was taken. If S_TRANS_TYPE_CD is not "TAKEN," this value is "N/A."
 

PERIOD_NO_CD 
ColumnName  PERIOD_NO_CD 
Definition 
Name: Timesheet Period. Description: If S_TRANS_TYPE_CD is "TAKEN," this value will identify the period on which the leave was taken. If S_TRANS_TYPE_CD is not "TAKEN," this value is "N/A."
 

LINE_NO 
ColumnName  LINE_NO 
Definition 
Name: Timesheet Line Number. Description: If S_TRANS_TYPE_CD is "TAKEN," this value will identify the line number of the timesheet on which the leave was taken. If S_TRANS_TYPE_CD is not "TAKEN," this value is zero.
 

LEAVE_HRS 
ColumnName  LEAVE_HRS 
Definition 
Name: Leave Hours. Description: The number of hours.
 

MODIFIED_BY 
ColumnName  MODIFIED_BY 
Definition 
Name: Modified By. Description: The User ID of the person who last modified this record.
 

ROWVERSION 
ColumnName  ROWVERSION 
Definition 
Name: Row Version. Description: The number of times this record has been updated.
 

TIME_STAMP 
ColumnName  TIME_STAMP 
Definition 
Name: Time Stamp. Description: Date and time the record was last modified.
 

ADJUSTMENT_TEXT 
ColumnName  ADJUSTMENT_TEXT 
Definition 
Name: Adjustment Comment. Description: The reason for an adjustment record.