EMPL_LEAVE 
Default Table Name  EMPL_LEAVE 
Definition 
 Name: Employee Leave .     Description: This table maintains employee leave transactions.
 

EMPL_LEAVE Columns 
ColumnName  Domain  Datatype  NULL  Definition 
EMPL_ID(PK)(FK)    VARCHAR2(20)  NO 
Name: Employee ID. Description: Unique identifier for the employee.
 
LEAVE_TYPE_CD(PK)(FK)    VARCHAR2(10)  NO 
Name: Leave Type. Description: Unique identifier for the type of leave.
 
TRANS_DT(PK)    DATE  NO 
Name: Transaction Date. Description: Date of Transaction.
 
S_TRANS_TYPE_CD(PK)    VARCHAR2(10)  NO 
Name: Transaction Type. Description: The type of transaction. Valid options are as follows: BEG - Beginning Balance. . TAKEN - Taken. ADJUSTMENT - Adjustment. 
 
TS_SCHEDULE_CD(PK)    VARCHAR2(10)  NO 
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(PK)    VARCHAR2(4)  NO 
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(PK)    VARCHAR2(3)  NO 
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(PK)    NUMBER(10, 0)  NO 
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    NUMBER(10, 4)  NO 
Name: Leave Hours. Description: The number of hours.
 
MODIFIED_BY    VARCHAR2(20)  NO 
Name: Modified By. Description: The User ID of the person who last modified this record.
 
ROWVERSION    NUMBER(10, 0)  NO 
Name: Row Version. Description: The number of times this record has been updated.
 
TIME_STAMP    DATE  NO 
Name: Time Stamp. Description: Date and time the record was last modified.
 
ADJUSTMENT_TEXT    VARCHAR2(60)  YES 
Name: Adjustment Comment. Description: The reason for an adjustment record.
 

EMPL_LEAVE Primary and Unique Keys 
Key Name  Key Type  Keys 
PI_0110  PrimaryKey  EMPL_ID, LEAVE_TYPE_CD, TRANS_DT, S_TRANS_TYPE_CD, TS_SCHEDULE_CD, YEAR_NO_CD, PERIOD_NO_CD, LINE_NO 

EMPL_LEAVE Foreign Keys 
Parent Relationships: 
Table Name  Type  Cardinality  Constraint Name  VerbPhrase  InversePhrase  Foreign Keys  Is Supertype  Deferrable 
EMPL  Identifying  One To Zero or More  F00078      EMPL_ID  NO  NO 
LEAVE_TYPE  Identifying  One To Zero or More  F00079      LEAVE_TYPE_CD  NO  NO 
Child Relationships: 
Table Name  Type  Cardinality  Constraint Name  VerbPhrase  InversePhrase  Foreign Keys  Is Subtype  Deferrable