PROCESS_INSTANCEGP_UPG_RCP_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 | RECIPIENT_ID | Character(8) | VARCHAR2(8) NOT NULL | Payment recipient ID |
| 3 | DEP_SCHED_ID | Character(10) | VARCHAR2(10) NOT NULL | Deposit Schedule |
| 4 | PURPOSE1 | Character(35) | VARCHAR2(35) NOT NULL | Purpose 1 |
| 5 | PURPOSE2 | Character(35) | VARCHAR2(35) NOT NULL | Purpose 2 |
| 6 | PIN_NUM | Number(8,0) | INTEGER NOT NULL | PIN Number |