COMP_TIME_PLANEFFDTDefault Value: %Date
A=Active
I=Inactive
Default Value: A
D=Days
M=Months
N=Never
Y=Years
Default Value: N
Default Value: TL_COMP_TIME.DESCR
Y/N Table Edit
Default Value: N
Y/N Table Edit
Default Value: N
TL_COMP_TIME(SQL Table) |
Index Back |
|---|---|
Compensatory Time Off TableThis record is used to define the Compensatory Time Off Plans within Time & Labor. |
| # | PeopleSoft Field Name | PeopleSoft Field Type | Database Column Type | Description |
|---|---|---|---|---|
| 1 | COMP_TIME_PLAN |
Character(10) | VARCHAR2(10) NOT NULL | Compensatory Time Off Plan |
| 2 | EFFDT |
Date(10) | DATE NOT NULL |
Effective Date
Default Value: %Date |
| 3 | EFF_STATUS | Character(1) | VARCHAR2(1) NOT NULL |
Effective Status
A=Active I=Inactive Default Value: A |
| 4 | EXPIRE_PER | Character(1) | VARCHAR2(1) NOT NULL |
Expiration Period
D=Days M=Months N=Never Y=Years Default Value: N |
| 5 | EXPIRE_NUM | Number(3,0) | SMALLINT NOT NULL | Period Count |
| 6 | DESCR | Character(30) | VARCHAR2(30) NOT NULL | Description |
| 7 | DESCRSHORT | Character(10) | VARCHAR2(10) NOT NULL |
Short Description
Default Value: TL_COMP_TIME.DESCR |
| 8 | HRS_GO_POSITIVE | Character(1) | VARCHAR2(1) NOT NULL |
This Field is used as an Indicator to limit Positive Compensatory Time Off Plan
Y/N Table Edit Default Value: N |
| 9 | MAX_POS_HRS | Number(4,0) | SMALLINT NOT NULL | Max Positive Hours Allowed |
| 10 | HRS_GO_NEGATIVE | Character(1) | VARCHAR2(1) NOT NULL |
Allow Negative Balance
Y/N Table Edit Default Value: N |
| 11 | MAX_NEG_HRS | Number(4,0) | SMALLINT NOT NULL | This Field is used to Define Maximum Positive Hours Allowed for a Compensatory Time Off Plan and for Leave Plan |