GP_PKG_IDCOMPANYEFFDTCONT_SAL_TYPE_BRA1=Monthly
2=Fortnightly
3=Weekly
4=Daily
5=Hourly
6=Per Task
7=Commission
8=Other
GPBR_ELEM_TYPEER=Earning
RC=Rate Code
COMP_RATECDPIN_NUMGPBR_NRP_RAC_AD(SQL Table) |
Index Back |
|---|---|
RAIS Contractual Salary BRARAIS Contractual Salary BRA |
| # | PeopleSoft Field Name | PeopleSoft Field Type | Database Column Type | Description |
|---|---|---|---|---|
| 1 | GP_PKG_ID |
Character(10) | VARCHAR2(10) NOT NULL | Field used for element packaging |
| 2 | COMPANY |
Character(3) | VARCHAR2(3) NOT NULL | Company |
| 3 | EFFDT |
Date(10) | DATE | Effective Date |
| 4 | CONT_SAL_TYPE_BRA |
Character(1) | VARCHAR2(1) NOT NULL |
Contract Salary Type Brazil
1=Monthly 2=Fortnightly 3=Weekly 4=Daily 5=Hourly 6=Per Task 7=Commission 8=Other |
| 5 | GPBR_ELEM_TYPE |
Character(2) | VARCHAR2(2) NOT NULL |
Element Type for Contract Salary
ER=Earning RC=Rate Code |
| 6 | COMP_RATECD |
Character(6) | VARCHAR2(6) NOT NULL | Comp Rate Code |
| 7 | PIN_NUM |
Number(8,0) | INTEGER NOT NULL | PIN Number |