OPRIDRUN_CNTL_IDSETIDPrompt Table: SETID_TBL
LOCATIONPrompt Table: GPDE_AL_PE_LOC
LANGUAGE_CDGPDE_RC_LOC_LNG(SQL Table) |
Index Back |
|---|---|
Location Table for Run ControlThis record is used on the Run Control page to store multiple locations per Operator ID/ Run Control ID. It is currently used in the eStatistic process, AL06, and stores additional values which must be reported for this process. It allows the user to input number of total hours on the last 3 days of the month, as well as special circumstances for why employees received additional payments. |
| # | 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 | RUN_CNTL_ID |
Character(30) | VARCHAR2(30) NOT NULL | Run Control ID |
| 3 | SETID |
Character(5) | VARCHAR2(5) NOT NULL |
SetID
Prompt Table: SETID_TBL |
| 4 | LOCATION |
Character(10) | VARCHAR2(10) NOT NULL |
Location Code
Prompt Table: GPDE_AL_PE_LOC |
| 5 | LANGUAGE_CD |
Character(3) | VARCHAR2(3) NOT NULL | Language Code |
| 6 | DESCR50 | Character(50) | VARCHAR2(50) NOT NULL | Description of length 50 |
| 7 | DESCR50_1 | Character(50) | VARCHAR2(50) NOT NULL | Description of length 50 |
| 8 | DESCR254 | Character(254) | VARCHAR2(254) NOT NULL | Description of length 254 |
| 9 | DESCR254A | Character(254) | VARCHAR2(254) NOT NULL | Long Description |
| 10 | DESCR254B | Character(254) | VARCHAR2(254) NOT NULL | Description of length 254 |
| 11 | DESCR254C | Character(254) | VARCHAR2(254) NOT NULL | Description of length 254 |
| 12 | DESCR254_1 | Character(254) | VARCHAR2(254) NOT NULL | Description of length 254 |