GP_PKG_IDGPAU_STP_RPT1=PAYEVNT
2=PAYEVNTEMP
3=ALL
EFFDTGPAU_STP_IS_CATGPAU_STP_SUB_CATGPAU_STP_S_CAT_DESSEQ_NUMPIN_NUMA=Add
S=Subtract
Default Value: A
DD=Deductions
ER=Earnings
GPAU_STPRSR_AD(SQL Table) |
Index Back |
|---|---|
Non Rule ADS record STP ReconNon Rule ADS record STP Reconciliation |
| # | 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 | GPAU_STP_RPT |
Character(30) | VARCHAR2(30) NOT NULL |
STP Report Values
1=PAYEVNT 2=PAYEVNTEMP 3=ALL |
| 3 | EFFDT |
Date(10) | DATE | Effective Date |
| 4 | GPAU_STP_IS_CAT |
Character(30) | VARCHAR2(30) NOT NULL | Category Information - Single Touch Payroll |
| 5 | GPAU_STP_SUB_CAT |
Character(30) | VARCHAR2(30) NOT NULL | STP Sub-Category |
| 6 | GPAU_STP_S_CAT_DES |
Character(40) | VARCHAR2(40) NOT NULL | STP Category Description |
| 7 | SEQ_NUM |
Number(3,0) | SMALLINT NOT NULL | Sequence |
| 8 | PIN_NUM |
Number(8,0) | INTEGER NOT NULL | PIN Number |
| 9 | ACM_SIGN | Character(1) | VARCHAR2(1) NOT NULL |
Accumulator Sign
A=Add S=Subtract Default Value: A |
| 10 | GP_RECELEM_TYPE | Character(4) | VARCHAR2(4) NOT NULL |
Element Type
DD=Deductions ER=Earnings |