PROCESS_INSTANCEINSTITUTIONBUSINESS_UNITSESSION_NOGIFT_NOGIFT_DTEMPLIDEXT_ORG_IDRECOGNITION_TYPEAV_TRNS_PP_AET(SQL Table) |
Index Back |
|---|---|
Pldg Pmt Trans State RecordUsed in the Accumulator processes to hold Pledge Payment RCGDES information for FY Designation accumulation. |
| # | PeopleSoft Field Name | PeopleSoft Field Type | Database Column Type | Description |
|---|---|---|---|---|
| 1 | PROCESS_INSTANCE |
Number(10,0) | DECIMAL(10) NOT NULL | Process Instance |
| 2 | INSTITUTION |
Character(5) | VARCHAR2(5) NOT NULL | Academic Institution |
| 3 | BUSINESS_UNIT |
Character(5) | VARCHAR2(5) NOT NULL | Business Unit |
| 4 | SESSION_NO |
Character(11) | VARCHAR2(11) NOT NULL | Session Nbr |
| 5 | GIFT_NO |
Character(11) | VARCHAR2(11) NOT NULL | Gift Nbr |
| 6 | GIFT_DT |
Date(10) | DATE | Gift Date |
| 7 | EMPLID |
Character(11) | VARCHAR2(11) NOT NULL | Employee ID |
| 8 | EXT_ORG_ID |
Character(11) | VARCHAR2(11) NOT NULL | External Org ID |
| 9 | RECOGNITION_TYPE |
Character(1) | VARCHAR2(1) NOT NULL | Recognition Type |
| 10 | FISCAL_YEAR | Number(4,0) | SMALLINT NOT NULL | Fiscal Year |
| 11 | RCVD_DT | Date(10) | DATE | Received Date |
| 12 | RCVD_AMT_CALC | Number(21,7) | DECIMAL(20,7) NOT NULL | Received Amount |
| 13 | CURRENCY_CD | Character(3) | VARCHAR2(3) NOT NULL | Currency Code |
| 14 | NTFY_FLG | Character(1) | VARCHAR2(1) NOT NULL | Notification Sent |
| 15 | GIFT_REF_NO | Character(11) | VARCHAR2(11) NOT NULL | Gift Reference Number |
| 16 | RCG_DES_AMT_CALC | Number(21,7) | DECIMAL(20,7) NOT NULL | Amount |
| 17 | DESIGNATION | Character(11) | VARCHAR2(11) NOT NULL | Designation |
| 18 | INTV_CD | Character(10) | VARCHAR2(10) NOT NULL | Initiative Code |
| 19 | GIFT_TYPE | Character(6) | VARCHAR2(6) NOT NULL | Gift Type |
| 20 | AV_DES_BU | Character(5) | VARCHAR2(5) NOT NULL | Business Unit |