GPAU_SS_AET

(SQL Table)
Index Back

State record for SuperStream

State record for Australia SuperStream 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 Number(10,0) DECIMAL(10) 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