GPAU_RC_SUPEREC

(SQL Table)
Index Back

GPAU - SuperEC Run Control

This is the run control record for SuperEC processing.

# PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description
1 OPRID Character(30) VARCHAR2(30) NOT NULL A user's ID (see PSOPRDEFN).
2 RUN_CNTL_ID Character(30) VARCHAR2(30) NOT NULL Run Control ID
3 PAY_ENTITY Character(10) VARCHAR2(10) NOT NULL Pay Entity

Prompt Table: GP_PYENT_OPR_VW

4 GPAU_PAYENTITY Character(10) VARCHAR2(10) NOT NULL Pay Entity

Prompt Table: GPAU_PENT_EC_VW

5 GPAU_REPORT_TYPE1 Character(1) VARCHAR2(1) NOT NULL Superannuation Report Type.
A=Agest
C=ComSuper
D=SuperStream
S=SuperEC

Default Value: C

6 CAL_RUN_ID Character(18) VARCHAR2(18) NOT NULL Calendar Run Id

Prompt Table: GPAU_CAL_RUN_VW

7 DATE_FROM Date(10) DATE NOT NULL Date From
8 DATE_TO Date(10) DATE NOT NULL Previous Period Date To
9 GPAU_PAY_RUN_NBR Number(8,0) INTEGER NOT NULL This is the Payroll run number for com-super
10 GPAU_ACKREQUEST Character(1) VARCHAR2(1) NOT NULL GPAUS - Indicator for SuperEC processing. When checked it means that the sender wishes to receive an acknowledgement after a SuperEC message file is sent.

Y/N Table Edit

Default Value: Y

11 GPAU_TESTINDICATOR Character(1) VARCHAR2(1) NOT NULL GPAUS - Indicates if a SuperEC message file is a test file only. Used in SuperEC processing.

Y/N Table Edit

Default Value: N

12 GPAU_SNDRTRANSFUNC Character(1) VARCHAR2(1) NOT NULL GPAUS - Flag to indicate if the SuperEC message file to be created is a replacement for a file with errors.

Y/N Table Edit

Default Value: N

13 GPAU_SNDRPRVTRNMSG Number(15,0) DECIMAL(15) NOT NULL GPAUS - used to indicate that a SuperEC file is a replacement for a previous file that had errors.

Prompt Table: GPAU_SUPTRN_VW1

14 GPAU_DUPLICATE_IND Character(1) VARCHAR2(1) NOT NULL GPAUS - In SuperEC processing, when this field is checked it indicates to the receiver of the SuperEC message file that the file is a replacement for one that was previously lost.

Y/N Table Edit

Default Value: N

15 GPAU_INTERCHANGEID Character(30) VARCHAR2(30) NOT NULL GPAUS - Used as an identifier on a SuperEC message file.

Prompt Table: GPAU_SUPTRN_VW2

16 GPAU_COMSUPR_RCTYP Character(4) VARCHAR2(4) NOT NULL GPAUS - Store the ComSuper record type for the ComSuper CCD file.
17 GPAU_COMSUPS_RCTYP Character(4) VARCHAR2(4) NOT NULL GPAUS - Stores the ComSuper record type value for the SED file.