GP_PKG_IDGPMX_FORMAT_IDEFFDTA=Active
I=Inactive
10=Include
20=Exclude
10=Include
20=Exclude
A=Use Accumulators
S=Selected Elements
Default Value: S
GPMX_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 | GPMX_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 | GPMX_PIN_PSLP1_NUM | Number(8,0) | INTEGER NOT NULL | Total Earnings Accumulator for Payslip |
| 8 | GPMX_PIN_PSLP2_NUM | Number(8,0) | INTEGER NOT NULL | Total Deductions. Payslip accumulator. |
| 9 | GPMX_PIN_PSLP3_NUM | Number(8,0) | INTEGER NOT NULL | Net Payment Accumulator for Payslip |
| 10 | GPMX_EARN_IE | Character(2) | VARCHAR2(2) NOT NULL |
Earnings Include/Exclude
10=Include 20=Exclude |
| 11 | GPMX_DED_IE | Character(2) | VARCHAR2(2) NOT NULL |
Deduction Include/Exclude
10=Include 20=Exclude |
| 12 | GPMX_SELECT_ALL1 | Character(1) | VARCHAR2(1) NOT NULL | Select All Elements |
| 13 | GPMX_SELECT_ALL2 | Character(1) | VARCHAR2(1) NOT NULL | Select All Members |
| 14 | GPMX_TOTAL_OPTN | Character(1) | VARCHAR2(1) NOT NULL |
Payslip gross and Net option
A=Use Accumulators S=Selected Elements Default Value: S |