TL_RESPRF_TBL(SQL Table) |
Index Back |
|---|---|
Restriction Profiles |
| # | PeopleSoft Field Name | PeopleSoft Field Type | Database Column Type | Description |
|---|---|---|---|---|
| 1 |  RESTRICTION_PRF_ID |
Character(10) | VARCHAR2(10) NOT NULL | Restriction Profile ID |
| 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 | DESCR | Character(30) | VARCHAR2(30) NOT NULL | Description |
| 5 | DESCRSHORT | Character(10) | VARCHAR2(10) NOT NULL |
Short Description
Default Value: TL_RESPRF_TBL.DESCR |
| 6 | RES_UNSCHED_MEAL | Character(1) | VARCHAR2(1) NOT NULL |
Restrict Unsched Meal Punch
Y/N Table Edit Default Value: N |
| 7 | RES_EARLY_IN | Character(1) | VARCHAR2(1) NOT NULL |
Restrict Early In Indicator
Y/N Table Edit Default Value: N |
| 8 | EARLY_IN_PUNCH | Number(3,0) | SMALLINT NOT NULL | Early In-Punch Margin (Mins) |
| 9 | RES_LATE_IN | Character(1) | VARCHAR2(1) NOT NULL |
Restrict Late In Indicator
Y/N Table Edit Default Value: N |
| 10 | LATE_IN_PUNCH | Number(3,0) | SMALLINT NOT NULL | Late In-Punch Margin (Mins) |
| 11 | RES_EARLY_OUT | Character(1) | VARCHAR2(1) NOT NULL |
Restrict Early Out Indicator
Y/N Table Edit Default Value: N |
| 12 | EARLY_OUT_PUNCH | Number(3,0) | SMALLINT NOT NULL | Early Out-Punch Margin (Mins) |
| 13 | RES_LATE_OUT | Character(1) | VARCHAR2(1) NOT NULL |
Restrict Late Out Indicator
Y/N Table Edit Default Value: N |
| 14 | LATE_OUT_PUNCH | Number(3,0) | SMALLINT NOT NULL | Late Out-Punch Margin (Mins) |
| 15 | RES_EARLY_MEAL | Character(1) | VARCHAR2(1) NOT NULL |
Restrict Early Meal Indicator
Y/N Table Edit Default Value: N |
| 16 | EARLY_MEAL | Number(3,0) | SMALLINT NOT NULL | Early Meal Margin (Mins) |
| 17 | RES_LATE_MEAL | Character(1) | VARCHAR2(1) NOT NULL |
Restrict Late Meal Indicator
Y/N Table Edit Default Value: N |
| 18 | LATE_MEAL | Number(3,0) | SMALLINT NOT NULL | Late Meal Margin (Mins) |
| 19 | RES_EARLY_BREAK | Character(1) | VARCHAR2(1) NOT NULL |
Restrict Early Break Indicator
Y/N Table Edit Default Value: N |
| 20 | EARLY_BREAK | Number(3,0) | SMALLINT NOT NULL | Early Break Margin (Mins) |
| 21 | RES_LATE_BREAK | Character(1) | VARCHAR2(1) NOT NULL |
Restrict Late Break Indicator
Y/N Table Edit Default Value: N |
| 22 | LATE_BREAK | Number(3,0) | SMALLINT NOT NULL | Late Break Margin (Mins) |