GPAU_RCPPAY_AET(SQL Table) |
Index Back |
---|---|
State Record for RCP AEState 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 |