GPAU_RCPPAY_AET

(SQL Table)
Index Back

State Record for RCP AE

State record for recipient payment file applciation engine.

# PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description
1 PROCESS_INSTANCE Number(10,0) DECIMAL(10) NOT NULL Process Instance
2 GPAU_RCP_GROUP_ID Character(18) VARCHAR2(18) NOT NULL The Group ID is required for the file generated by GPAU_RCPFILE.
3 PAY_ENTITY Character(10) VARCHAR2(10) NOT NULL Pay Entity
4 OPRID Character(30) VARCHAR2(30) NOT NULL A user's ID (see PSOPRDEFN).
5 RUN_CNTL_ID Character(30) VARCHAR2(30) NOT NULL Run Control ID
6 DEBIT_DT Date(10) DATE Debit Date
7 PAYMENT_DT Date(10) DATE Payment Date
8 GPAU_RCPNT_OPTN Character(2) VARCHAR2(2) NOT NULL This is used to identify the recipient option.
10=Select Recipients Only
20=All Recipients
30=Deduction
9 GPAU_RCP_CAL_OPTN Character(2) VARCHAR2(2) NOT NULL This field is used to identify the calculation option to use.
10=Recipient ID
20=All Recipients
30=Deduction
10 GPAU_RCP_COMM_TYPE Character(2) VARCHAR2(2) NOT NULL The commission type determines if a payment amount is reduced when paying a recipient.
10=Flat Amount
20=Percentage
30=None
11 PIN_NUM Number(8,0) INTEGER NOT NULL PIN Number
12 RECIPIENT_ID Character(8) VARCHAR2(8) NOT NULL Payment recipient ID
13 ERROR_TYPE Character(3) VARCHAR2(3) NOT NULL Error Type
ERR=Stop
NON=None
WAR=Warning
14 ERROR_CNT Number(4,0) SMALLINT NOT NULL Error Count
15 GPAU_MEMBER_ID Character(18) VARCHAR2(18) NOT NULL The Membership Group ID is required for the file generated by GPAU_RCPFILE.
16 EMPLID Character(11) VARCHAR2(11) NOT NULL Employee ID
17 EMPL_RCD Number(3,0) SMALLINT NOT NULL Empl Rcd Nbr