GPAU_STP_CATRECNAMEPrompt Table: PSRECDEFN
XML_ITERATIVEY/N Table Edit
Default Value: N
EFFDTDefault Value: %date
Y/N Table Edit
Default Value: N
Y/N Table Edit
Default Value: Y
A=Active
I=Inactive
Default Value: A
GPAU_STP_CAT_DT(SQL Table) |
Index Back |
|---|---|
STP Category SetupSTP Category Setup for Australia |
| # | PeopleSoft Field Name | PeopleSoft Field Type | Database Column Type | Description |
|---|---|---|---|---|
| 1 | GPAU_STP_CAT |
Character(30) | VARCHAR2(30) NOT NULL | Category Information - Single Touch Payroll |
| 2 | RECNAME |
Character(15) | VARCHAR2(15) NOT NULL |
Record (Table) Name (see PSRECDEFN).
Prompt Table: PSRECDEFN |
| 3 | XML_ITERATIVE |
Character(1) | VARCHAR2(1) NOT NULL |
Iterative node
Y/N Table Edit Default Value: N |
| 4 | EFFDT |
Date(10) | DATE NOT NULL |
Effective Date
Default Value: %date |
| 5 | GPAU_STP_CAT_DESCR | Character(50) | VARCHAR2(50) NOT NULL | Category Description - Single Touch Payroll |
| 6 | GPAU_ENABLE_PTD | Character(1) | VARCHAR2(1) NOT NULL |
This indicator helps us to identify if PTD needs to be reported in STP
Y/N Table Edit Default Value: N |
| 7 | GPAU_ENABLE_YTD | Character(1) | VARCHAR2(1) NOT NULL |
This indicator helps us to identify if YTD needs to be reported in STP
Y/N Table Edit Default Value: Y |
| 8 | STATUS | Character(1) | VARCHAR2(1) NOT NULL |
Status Indicator
A=Active I=Inactive Default Value: A |