TL_PE_OPR_MGRWA(SQL Table) |
Index Back |
|---|---|
Wrkfrc Availability SettingsPersonalization settings for Time Management pagelet |
| # | PeopleSoft Field Name | PeopleSoft Field Type | Database Column Type | Description |
|---|---|---|---|---|
| 1 |  OPRID |
Character(30) | VARCHAR2(30) NOT NULL | A user's ID (see PSOPRDEFN). |
| 2 | USER_FIELD_1_FLAG | Character(1) | VARCHAR2(1) NOT NULL |
Currently Clocked In
N=Not Used O=Optional R=Required Y/N Table Edit Default Value: Y |
| 3 | USER_FIELD_2_FLAG | Character(1) | VARCHAR2(1) NOT NULL |
No Show for Current Shift
N=Not Used O=Optional R=Required Y/N Table Edit Default Value: Y |
| 4 | USER_FIELD_3_FLAG | Character(1) | VARCHAR2(1) NOT NULL |
Scheduled for Current Shift
N=Not Used O=Optional R=Required Y/N Table Edit Default Value: Y |
| 5 | USER_FIELD_4_FLAG | Character(1) | VARCHAR2(1) NOT NULL |
Reported Absent for Today
N=Not Used O=Optional R=Required Y/N Table Edit Default Value: Y |
| 6 | USER_FIELD_5_FLAG | Character(1) | VARCHAR2(1) NOT NULL |
Reported In Training for Today
N=Not Used O=Optional R=Required Y/N Table Edit Default Value: Y |