GP_PKG_IDGPBR_FORMAT_IDEFFDTA=Active
I=Inactive
10=Include
20=Exclude
10=Include
20=Exclude
GPBR_NRP_PYF_AD(SQL Table) |
Index Back |
|---|---|
PaySlip FormatGeneral Data PaySlip |
| # | 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 | GPBR_FORMAT_ID |
Character(10) | VARCHAR2(10) NOT NULL | Format ID |
| 3 | EFFDT |
Date(10) | DATE | Effective Date |
| 4 | EFF_STATUS | Character(1) | VARCHAR2(1) NOT NULL |
Effective Status
A=Active I=Inactive |
| 5 | DESCR | Character(30) | VARCHAR2(30) NOT NULL | Description |
| 6 | DESCRSHORT | Character(10) | VARCHAR2(10) NOT NULL | Short Description |
| 7 | GPBR_PIN_PSLP1_NUM | Number(8,0) | INTEGER NOT NULL | Total Earnings. Accumulator for Payslip |
| 8 | GPBR_PIN_PSLP2_NUM | Number(8,0) | INTEGER NOT NULL | Total Earnings. Accumulator for Payslip |
| 9 | GPBR_PIN_PSLP3_NUM | Number(8,0) | INTEGER NOT NULL | Net Pay. Accumulator for Payslip |
| 10 | GPBR_EARN_IE | Character(2) | VARCHAR2(2) NOT NULL |
Earnings Include/Exclude
10=Include 20=Exclude |
| 11 | GPBR_DED_IE | Character(2) | VARCHAR2(2) NOT NULL |
Deduction Include/Exclude
10=Include 20=Exclude |
| 12 | GPBR_SELECT_ALL1 | Character(1) | VARCHAR2(1) NOT NULL | Select All Elements |
| 13 | GPBR_SELECT_ALL2 | Character(1) | VARCHAR2(1) NOT NULL | Select All |
| 14 | GPBR_PSLP1_LCODE | Character(7) | VARCHAR2(7) NOT NULL | Legal Code |
| 15 | GPBR_PSLP2_LCODE | Character(7) | VARCHAR2(7) NOT NULL | Legal Code |
| 16 | GPBR_PSLP3_LCODE | Character(7) | VARCHAR2(7) NOT NULL | Legal Code |