GPAU_SS_COM_AET

(SQL Table)
Index Back

State record for ComSuper

State record for Australia ComSuper reporting process.

# PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description
1 PROCESS_INSTANCE Number(10,0) DECIMAL(10) NOT NULL Process Instance
2 OPRID Character(30) VARCHAR2(30) NOT NULL A user's ID (see PSOPRDEFN).
3 RUN_CNTL_ID Character(30) VARCHAR2(30) NOT NULL Run Control ID
4 CAL_RUN_ID Character(18) VARCHAR2(18) NOT NULL Calendar Run Id
5 RECIPIENT_ID Character(8) VARCHAR2(8) NOT NULL Payment recipient ID
6 PAY_ENTITY Character(10) VARCHAR2(10) NOT NULL Pay Entity
7 COUNTER Signed Number(6,0) DECIMAL(5) NOT NULL Counter
8 DATE_FROM Date(10) DATE Date From
9 DATE_TO Date(10) DATE Previous Period Date To
10 REF_EFFDT Date(10) DATE Effective Date
11 EMPLID Character(11) VARCHAR2(11) NOT NULL Employee ID
12 PREV_EMPLID Character(11) VARCHAR2(11) NOT NULL Previous Employee ID
13 CONTINUE_AE_FLAG Character(1) VARCHAR2(1) NOT NULL Continue AE Processing flag
14 PIN_NUM Number(8,0) INTEGER NOT NULL PIN Number
15 GPAU_LODGEMENT_REF Character(50) VARCHAR2(50) NOT NULL This field is used in the AE program GPAU_EFT_CMX.
16 GPAU_SMART_KEY Character(90) VARCHAR2(90) NOT NULL Primary Key used in SuperStream reporting
17 GPAU_PYENT_IND Character(1) VARCHAR2(1) NOT NULL Pay Entity Indicator
18 WHERE_CLAUSE Long Character(500) VARCHAR2(500) Where Clause
19 GPAU_NEG_ALLOW Character(1) VARCHAR2(1) NOT NULL Allow Negatives
20 GPAU_SENDERID Character(30) VARCHAR2(30) NOT NULL GPAUS - Stores the ID of the Sender for SuperEC processing.
21 GPAU_RECEIVERID Character(30) VARCHAR2(30) NOT NULL GPAUS - Stores the ID of the Super Fund Administrator that is to receive a SuperEC message file.
22 GPAU_PAYERID Character(9) VARCHAR2(9) NOT NULL Payer ID
23 GPAU_ORG_LINK_OPTN Character(2) VARCHAR2(2) NOT NULL Identifies at what org level source banks are assigned. Value set at this time: Company, Dept, Location, Pay Entity, Pay Group
CO=Company
DE=Department
PG=Pay Group
RE=Recipient
24 GPAU_PAYEEID Character(20) VARCHAR2(20) NOT NULL Payee ID
25 GPAU_SS_RPT_OPTION Character(1) VARCHAR2(1) NOT NULL SuperStream Report generation option
B=CSV & XBRL
C=CSV Only
X=XBRL Only
26 GPAU_XBRL_FILE Character(200) VARCHAR2(200) NOT NULL XBRL File Name
27 URL_ID Character(30) VARCHAR2(30) NOT NULL URL Identifier (see PSURLDEFN).
28 GPAU_XMLSET_REG Character(5) VARCHAR2(5) NOT NULL XML Set
29 GPAU_TMPLT_REG Character(3) VARCHAR2(3) NOT NULL Template type
30 GPAU_XMLSET_CTR Character(5) VARCHAR2(5) NOT NULL XML Set
31 GPAU_TMPLT_CTR Character(3) VARCHAR2(3) NOT NULL Template type
32 GPAU_SINGLE_FILE Character(1) VARCHAR2(1) NOT NULL Generate Single CSV
33 GPAU_COM_SCM_OPT Character(1) VARCHAR2(1) NOT NULL ComSuper Schemeas to be reported
A=PSSap Only
B=CSS & PSS
C=CSS Only
P=PSS Only
X=All Funds
34 WHERE_CLAUSE1 Character(254) VARCHAR2(254) NOT NULL Where Clause