UNION_CDPrompt Table: UNION_TBL
EFFDTDefault Value: GPBR_UNION_PARM.EFFDT
GPBR_PROCESS_TYPE10=Vacations
20=Overtime
30=13th Salary
Default Value: 10
GPBR_PIN_SAL_NUMPrompt Table: GPBR_PIN_ER_VW
GPBR_NRP_USA_VW(SQL View) |
Index Back |
|---|---|
Union Salary BaseUnion Salary Base record for Brazil |
| SELECT UNION_CD ,EFFDT ,GPBR_PROCESS_TYPE ,GPBR_PIN_SAL_NUM + 50000000 ,GPBR_UNION_SAL_PCT FROM PS_GPBR_UNION_SAL |
| # | PeopleSoft Field Name | PeopleSoft Field Type | Database Column Type | Description |
|---|---|---|---|---|
| 1 | UNION_CD |
Character(3) | VARCHAR2(3) NOT NULL |
Union Code
Prompt Table: UNION_TBL |
| 2 | EFFDT |
Date(10) | DATE NOT NULL |
Effective Date
Default Value: GPBR_UNION_PARM.EFFDT |
| 3 | GPBR_PROCESS_TYPE |
Character(2) | VARCHAR2(2) NOT NULL |
Process Type
10=Vacations 20=Overtime 30=13th Salary Default Value: 10 |
| 4 | GPBR_PIN_SAL_NUM |
Number(8,0) | INTEGER NOT NULL |
Salary Base Element
Prompt Table: GPBR_PIN_ER_VW |
| 5 | GPBR_UNION_SAL_PCT | Number(3,0) | SMALLINT NOT NULL | Salary Percentage |