OPRIDRUN_CNTL_IDPrompt Table: ESTAB_TBL
1/0 Table Edit (1=True, 0=False)
Default Value: 0
GPBR_RC_GPS(SQL Table) |
Index Back |
|---|---|
GPS Run ControlGPS Run Control |
| # | 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 | ESTABID | Character(12) | VARCHAR2(12) NOT NULL |
Establishment ID
Prompt Table: ESTAB_TBL |
| 4 | GPBR_START_MONTH | Number(2,0) | SMALLINT NOT NULL | Start Month |
| 5 | GPBR_END_YEAR | Number(4,0) | SMALLINT NOT NULL | End Year |
| 6 | GPBR_FINE_PCT | Number(6,2) | DECIMAL(5,2) NOT NULL | Fine Percentage |
| 7 | GPBR_INTEREST_PCT | Number(6,2) | DECIMAL(5,2) NOT NULL | Interest Percentage |
| 8 | GPBR_RECALC_13 | Number(1,0) | SMALLINT NOT NULL |
13th Salary Recalculation
1/0 Table Edit (1=True, 0=False) Default Value: 0 |
| 9 | GPBR_AUTONOM_VAL | Number(18,2) | DECIMAL(17,2) NOT NULL | Autonomous Total Value |