GPAU_RC_SUPEREC(SQL Table) |
Index Back |
---|---|
GPAU - SuperEC Run ControlThis 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. |