PG_DREQ_00_EC(SQL Table) |
Index Back |
|---|
| # | PeopleSoft Field Name | PeopleSoft Field Type | Database Column Type | Description |
|---|---|---|---|---|
| 1 |  ECTRANSID |
Character(15) | VARCHAR2(15) NOT NULL | Electronic Commerce Transaction ID. Used in EDI Manager. One of three(3) Key Fields(ECTRANSID, ECTRANSINOUTSW, ECQUEUEINSTANCE) used in Electronic Commerce(EC) Staging Tables. ECTRANSID in EDI Manager identifies a transaction type(like "PO" for Purchase Orders) |
| 2 | ECQUEUEINSTANCE |
Number(9,0) | DECIMAL(9) NOT NULL | Electronic Commerce Queue Instance ID. Used in EDI Manager. One of three(3) Key Fields(ECTRANSID, ECTRANSINOUTSW, ECQUEUEINSTANCE) used in Electronic Commerce(EC) Staging Tables. |
| 3 | ECTRANSINOUTSW |
Character(1) | VARCHAR2(1) NOT NULL |
Electronic Commerce Inbound/Outbound Switch. Used in EDI Manager. One of three(3) Key Fields(ECTRANSID, ECTRANSINOUTSW, ECQUEUEINSTANCE) used in Electronic Commerce(EC) Staging Tables. The field value is "I" for Inbound Transactions, and "O" for Outbound.
I=Inbound O=Outbound Default Value: O |
| 4 | PG_DR_RECORD_NBR |
Number(5,0) | INTEGER NOT NULL | Data Request Record Seq Nbr |
| 5 | PG_REQUEST_SEQ | Number(5,0) | INTEGER NOT NULL | Request Sequence Number |
| 6 | TIV_SCHOOL_CODE | Character(6) | VARCHAR2(6) NOT NULL | Pell ID Reporting |
| 7 | PELL_ID_ATTENDED | Character(6) | VARCHAR2(6) NOT NULL | Attended Pell ID |
| 8 | PG_REQUEST_TYPE | Character(1) | VARCHAR2(1) NOT NULL |
Request Type
B=Batch Replacement M=Multiple Reporting R=Reconciliation Request S=Statement of Accounts Y=Year-To-Date |
| 9 | PG_MEDIA_TYPE | Character(1) | VARCHAR2(1) NOT NULL | Pell Media Type |
| 10 | PG_BATCH_ID_00 | Character(26) | VARCHAR2(26) NOT NULL | Pell Batch ID |
| 11 | PG_MULT_RQ_CD1 | Character(1) | VARCHAR2(1) NOT NULL |
Multiple Report Request Code 1
D=Disbursed Records O=Originated Records |
| 12 | PG_MULT_RQ_CD2 | Character(1) | VARCHAR2(1) NOT NULL |
Multiple Report Request Code 2
A=All Students I=Selected Institution S=Selected Students |
| 13 | PG_MR_STDNT_ID | Character(11) | VARCHAR2(11) NOT NULL | MRR Student ID |
| 14 | PG_MR_INST_PELL_ID | Character(6) | VARCHAR2(6) NOT NULL | MRR Institution Pell ID |
| 15 | PG_ACTION_CODE | Character(1) | VARCHAR2(1) NOT NULL | Action Code |
| 16 | PG_MSG_CODE_1 | Character(3) | VARCHAR2(3) NOT NULL | Message Code 1 |
| 17 | PG_MSG_CODE_2 | Character(3) | VARCHAR2(3) NOT NULL | Message Code 2 |
| 18 | PG_MSG_CODE_3 | Character(3) | VARCHAR2(3) NOT NULL | Message Code 3 |
| 19 | PG_MSG_CODE_4 | Character(3) | VARCHAR2(3) NOT NULL | Message Code 4 |
| 20 | PG_MSG_CODE_5 | Character(3) | VARCHAR2(3) NOT NULL | Message Code 5 |
| 21 | PG_MSG_CODE_6 | Character(3) | VARCHAR2(3) NOT NULL | Message Code 6 |
| 22 | PG_MSG_CODE_7 | Character(3) | VARCHAR2(3) NOT NULL | Message Code 7 |
| 23 | PG_MSG_CODE_8 | Character(3) | VARCHAR2(3) NOT NULL | Message Code 8 |
| 24 | PG_ORIGINATION_ID | Character(23) | VARCHAR2(23) NOT NULL | Pell Origination ID |
| 25 | PG_CURRENT_SSN | Character(9) | VARCHAR2(9) NOT NULL | Student Current SSN |
| 26 | PG_DATE_OF_BIRTH | Character(8) | VARCHAR2(8) NOT NULL | Pell Student Date of Birth |
| 27 | PG_LAST_NAME | Character(35) | VARCHAR2(35) NOT NULL | PG Last Name |
| 28 | PG_FIRST_NAME | Character(35) | VARCHAR2(35) NOT NULL | PG First Name |
| 29 | PG_MIDLE_INITIAL | Character(35) | VARCHAR2(35) NOT NULL | PG Middle Inital |
| 30 | SFA_CR_PROG_TYPE | Character(2) | VARCHAR2(2) NOT NULL | Program Type |