GPAU_STP_RPT1=PAYEVNT
2=PAYEVNTEMP
3=ALL
EFFDTGPAU_STP_IS_CATGPAU_STP_SUB_CATGPAU_STP_S_CAT_DESSEQ_NUMPIN_NUMPrompt Table: GPAU_STP_RPN_VW
A=Add
S=Subtract
Default Value: A
DD=Deductions
ER=Earnings
GPAU_STPRSR_VW(SQL View) |
Index Back |
|---|---|
Non Rule View STP ReconNon - Rule Export Record View for GPAU_STP_R_SRCT |
| SELECT GPAU_STP_RPT ,EFFDT ,GPAU_STP_IS_CAT ,GPAU_STP_SUB_CAT ,GPAU_STP_S_CAT_DES ,SEQ_NUM ,PIN_NUM + 50000000 ,ACM_SIGN ,GP_RECELEM_TYPE FROM PS_GPAU_STP_R_SRCT |
| # | PeopleSoft Field Name | PeopleSoft Field Type | Database Column Type | Description |
|---|---|---|---|---|
| 1 | GPAU_STP_RPT |
Character(30) | VARCHAR2(30) NOT NULL |
STP Report Values
1=PAYEVNT 2=PAYEVNTEMP 3=ALL |
| 2 | EFFDT |
Date(10) | DATE | Effective Date |
| 3 | GPAU_STP_IS_CAT |
Character(30) | VARCHAR2(30) NOT NULL | Category Information - Single Touch Payroll |
| 4 | GPAU_STP_SUB_CAT |
Character(30) | VARCHAR2(30) NOT NULL | STP Sub-Category |
| 5 | GPAU_STP_S_CAT_DES |
Character(40) | VARCHAR2(40) NOT NULL | STP Category Description |
| 6 | SEQ_NUM |
Number(3,0) | SMALLINT NOT NULL | Sequence |
| 7 | PIN_NUM |
Number(8,0) | INTEGER NOT NULL |
PIN Number
Prompt Table: GPAU_STP_RPN_VW |
| 8 | ACM_SIGN | Character(1) | VARCHAR2(1) NOT NULL |
Accumulator Sign
A=Add S=Subtract Default Value: A |
| 9 | GP_RECELEM_TYPE | Character(4) | VARCHAR2(4) NOT NULL |
Element Type
DD=Deductions ER=Earnings |