| # |
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: I
|
| 4 |
PG_RECORD_TYPE |
Character(2) |
VARCHAR2(2) NOT NULL |
Record Type
BC=Blocked and Concurrent Enroll
CE=Concurrent Enroll Institution
PB=Blocked Institution
PR=Blocker Institution
PU=Unblocked Institution
RC=Blocker and Concurrent Enroll
RD=Disbursed Institution
RN=None found
RO=Originated Institution
SI=Shared SAR ID
VW=Verification W
|
| 5 |
PG_MULTI_RPT_SEQ |
Number(5,0) |
INTEGER NOT NULL |
Mupltiple Reporting Seq
|
| 6 |
PG_REPORTING_ID |
Character(6) |
VARCHAR2(6) NOT NULL |
Pell Reporting Campus ID
|
| 7 |
PG_MULT_RQ_CD1 |
Character(1) |
VARCHAR2(1) NOT NULL |
Multiple Report Request Code 1
D=Disbursed Records
O=Originated Records
|
| 8 |
PG_MULT_RQ_CD2 |
Character(1) |
VARCHAR2(1) NOT NULL |
Multiple Report Request Code 2
A=All Students
I=Selected Institution
S=Selected Students
|
| 9 |
PG_MR_STDNT_ID |
Character(11) |
VARCHAR2(11) NOT NULL |
MRR Student ID
|
| 10 |
PG_MR_INST_PELL_ID |
Character(6) |
VARCHAR2(6) NOT NULL |
MRR Institution Pell ID
|
| 11 |
PG_STDNT_ORIG_SSN |
Character(9) |
VARCHAR2(9) NOT NULL |
Student Original SSN
|
| 12 |
PG_ORIG_NAME_CD |
Character(2) |
VARCHAR2(2) NOT NULL |
Original Name Code
|
| 13 |
TIV_SCHOOL_CODE |
Character(6) |
VARCHAR2(6) NOT NULL |
Pell ID Reporting
|
| 14 |
PG_INST_NAME |
Character(70) |
VARCHAR2(70) NOT NULL |
Pell Institution Name
|
| 15 |
PG_INST_ADDR_1 |
Character(35) |
VARCHAR2(35) NOT NULL |
Institution Address 1
|
| 16 |
PG_INST_ADDR_2 |
Character(35) |
VARCHAR2(35) NOT NULL |
Institution Address 2
|
| 17 |
PG_INST_CITY |
Character(25) |
VARCHAR2(25) NOT NULL |
Institution City
|
| 18 |
PG_INST_STATE |
Character(2) |
VARCHAR2(2) NOT NULL |
Institution State
|
| 19 |
PG_INST_ZIPCODE |
Character(9) |
VARCHAR2(9) NOT NULL |
Mailing Zip Code
|
| 20 |
PG_FAA_NAME |
Character(30) |
VARCHAR2(30) NOT NULL |
FAA Administrator Name
|
| 21 |
PG_FAA_PHONE_MR |
Character(10) |
VARCHAR2(10) NOT NULL |
FAA Telephone Number
|
| 22 |
PG_FAA_FAX_MR |
Character(10) |
VARCHAR2(10) NOT NULL |
FAA Fax Number
|
| 23 |
PG_FAA_EMAIL |
Character(50) |
VARCHAR2(50) NOT NULL |
FAA Email Address
|
| 24 |
PG_ORIG_AWDAMT |
Number(8,2) |
DECIMAL(7,2) NOT NULL |
Origination Award Amount
|
| 25 |
PG_TRANSACTION_NBR |
Number(2,0) |
SMALLINT NOT NULL |
Transaction Number
|
| 26 |
PG_ENROLL_DATE |
Date(10) |
DATE |
Enrollment Date
|
| 27 |
PG_ORIG_DATE |
Date(10) |
DATE |
Origination Create Date
|
| 28 |
PG_TOT_DISBACPT |
Number(8,2) |
DECIMAL(7,2) NOT NULL |
Total of Disbursement Accept
|
| 29 |
PG_LST_ACT_DATE |
Date(10) |
DATE |
Last Activity Date
|
| 30 |
PG_NXT_EST_DSB_DT |
Date(10) |
DATE |
Next Est Disbursement Date
|
| 31 |
PG_ED_USE_FLAG_1 |
Character(1) |
VARCHAR2(1) NOT NULL |
Ed Use Flag 1
1=Shared SAR ID
|
| 32 |
PG_ED_USE_FLAG_2 |
Character(1) |
VARCHAR2(1) NOT NULL |
Ed Use Flag 2
1=Verification W Status
|
| 33 |
PG_ED_USE_FLAG_3 |
Character(1) |
VARCHAR2(1) NOT NULL |
Ed Use Flag 3
1=Concurrent Enrollment
|
| 34 |
PG_ED_USE_FLAG_4 |
Character(1) |
VARCHAR2(1) NOT NULL |
Ed Use Flag 4
1=POP
|
| 35 |
PG_ED_USE_FLAG_5 |
Character(1) |
VARCHAR2(1) NOT NULL |
Ed Use Flag 5
|
| 36 |
PG_ED_USE_FLAG_6 |
Character(1) |
VARCHAR2(1) NOT NULL |
Ed Use Flag 6
|
| 37 |
PG_ED_USE_FLAG_7 |
Character(1) |
VARCHAR2(1) NOT NULL |
Ed Use Flag 7
|
| 38 |
PG_ED_USE_FLAG_8 |
Character(1) |
VARCHAR2(1) NOT NULL |
Ed Use Flag 8
|
| 39 |
PG_ED_USE_FLAG_9 |
Character(1) |
VARCHAR2(1) NOT NULL |
Ed Use Flag 9
|
| 40 |
PG_ED_USE_FLAG_10 |
Character(1) |
VARCHAR2(1) NOT NULL |
Ed Use Flag 10
|
| 41 |
PG_LAST_NAME |
Character(35) |
VARCHAR2(35) NOT NULL |
PG Last Name
|
| 42 |
PG_FIRST_NAME |
Character(35) |
VARCHAR2(35) NOT NULL |
PG First Name
|
| 43 |
PG_MIDLE_INITIAL |
Character(35) |
VARCHAR2(35) NOT NULL |
PG Middle Inital
|
| 44 |
PG_DATE_OF_BIRTH |
Character(8) |
VARCHAR2(8) NOT NULL |
Pell Student Date of Birth
|
| 45 |
PG_CURRENT_SSN |
Character(9) |
VARCHAR2(9) NOT NULL |
Student Current SSN
|
| 46 |
PROCESS_INSTANCE |
Number(10,0) |
DECIMAL(10) NOT NULL |
Process Instance
|
| 47 |
PG_STG_PROC_STAT |
Character(1) |
VARCHAR2(1) NOT NULL |
Pell Staging Rec Proc Status
E=Error
N=Not Processed
P=Processed
Default Value: N
|
| 48 |
PELL_TRANS_DTTM |
DateTime(26) |
TIMESTAMP |
Pell Trans Date/Time
|
| 49 |
SFA_CR_AWARD_ID |
Character(21) |
VARCHAR2(21) NOT NULL |
Award ID
|
| 50 |
PG_SCHED_PELL_GNT |
Number(8,2) |
DECIMAL(7,2) NOT NULL |
Scheduled Fed Pell Grant
|
| 51 |
PG_ELIG_USED |
Number(8,4) |
DECIMAL(7,4) NOT NULL |
Eligibility Used
|
| 52 |
SFA_COD_TOTAL_ELIG |
Number(8,4) |
DECIMAL(7,4) NOT NULL |
Total % of Eligibility Used
|