UNION_CDEFFDTDefault Value: %date
RUN_TYPEPrompt Table: GP_RUN_TYPE
GPBR_ENTRY_TYPE10=Earnings
20=Deductions
Default Value: 10
PIN_NUMPrompt Table: %RECNAME_EDIT
Prompt Table: GPBR_AVG_VERS
GPBR_NRP_AVG_VW(SQL View) |
Index Back |
|---|---|
Averages BrazilAverages Brazil |
| SELECT UNION_CD ,EFFDT ,RUN_TYPE ,GPBR_ENTRY_TYPE ,PIN_NUM + 50000000 ,GPBR_AVG_VERSION FROM PS_GPBR_AVERAGES_E |
| # | PeopleSoft Field Name | PeopleSoft Field Type | Database Column Type | Description |
|---|---|---|---|---|
| 1 | UNION_CD |
Character(3) | VARCHAR2(3) NOT NULL | Union Code |
| 2 | EFFDT |
Date(10) | DATE NOT NULL |
Effective Date
Default Value: %date |
| 3 | RUN_TYPE |
Character(10) | VARCHAR2(10) NOT NULL |
Run Type Name
Prompt Table: GP_RUN_TYPE |
| 4 | GPBR_ENTRY_TYPE |
Character(2) | VARCHAR2(2) NOT NULL |
Entry type element
10=Earnings 20=Deductions Default Value: 10 |
| 5 | PIN_NUM |
Number(8,0) | INTEGER NOT NULL |
PIN Number
Prompt Table: %RECNAME_EDIT |
| 6 | GPBR_AVG_VERSION | Character(10) | VARCHAR2(10) NOT NULL |
Averages BRA
Version
Prompt Table: GPBR_AVG_VERS |