| # |
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
|
| 4 |
ISIR_SEQ_NO |
Number(5,0) |
INTEGER NOT NULL |
Sequence Number
|
| 5 |
EMPLID |
Character(11) |
VARCHAR2(11) NOT NULL |
Employee ID
|
| 6 |
IWD_CURR_SSN |
Character(9) |
VARCHAR2(9) NOT NULL |
Current SSN
|
| 7 |
IWD_STD_LAST_NAME |
Character(35) |
VARCHAR2(35) NOT NULL |
Last Name
|
| 8 |
IWD_STD_FIRST_NM02 |
Character(35) |
VARCHAR2(35) NOT NULL |
Student's First Name
|
| 9 |
IWD_STU_MI |
Character(15) |
VARCHAR2(15) NOT NULL |
Student Middle Initial
|
| 10 |
IWD_PERM_ADDR02 |
Character(35) |
VARCHAR2(35) NOT NULL |
Permanent Mailing Address
|
| 11 |
IWD_CITY |
Character(16) |
VARCHAR2(16) NOT NULL |
City
|
| 12 |
IWD_STATE |
Character(2) |
VARCHAR2(2) NOT NULL |
State
|
| 13 |
IWD_ZIP |
Character(5) |
VARCHAR2(5) NOT NULL |
Zip
|
| 14 |
BIRTHDATE |
Date(10) |
DATE |
Date of Birth
|
| 15 |
IWD_PERM_PHONE |
Character(10) |
VARCHAR2(10) NOT NULL |
Perm Phone Number
|
| 16 |
IWD_HAVE_DL |
Character(1) |
VARCHAR2(1) NOT NULL |
Do You Have a Drivers License
|
| 17 |
DRIVERS_LICENSE_NO |
Character(20) |
VARCHAR2(20) NOT NULL |
Driver's License #
|
| 18 |
IWD_DL_STATE |
Character(2) |
VARCHAR2(2) NOT NULL |
Driver's License State Code
|
| 19 |
CITIZENSHIP_STATUS |
Character(1) |
VARCHAR2(1) NOT NULL |
Citizenship Status
|
| 20 |
IWD_STU_ALIEN_REG |
Character(9) |
VARCHAR2(9) NOT NULL |
Alien Registration Number
|
| 21 |
MARITAL_STAT |
Character(1) |
VARCHAR2(1) NOT NULL |
Marital Status
1=Single
2=Married
3=Separated
4=Divorced
5=Widowed
|
| 22 |
IWD_MAR_STAT_DT |
Character(6) |
VARCHAR2(6) NOT NULL |
Marital Status Date
|
| 23 |
ENROLL_CURNT_SUM |
Character(1) |
VARCHAR2(1) NOT NULL |
Enroll Plan for Current Sumr
1=Full Time
2=3/4 Time
3=1/2 Time
4=LT 1/2 Time
5=Not Attending
|
| 24 |
ENROLL_FALL |
Character(1) |
VARCHAR2(1) NOT NULL |
Enroll Plan for Fall
1=Full Time
2=3/4 Time
3=1/2 Time
4=LT 1/2 Time
5=Not Attending
|
| 25 |
ENROLL_WINTER |
Character(1) |
VARCHAR2(1) NOT NULL |
Enroll Plan for Winter
1=Full Time
2=3/4 Time
3=1/2 Time
4=LT 1/2 Time
5=Not Attending
|
| 26 |
ENROLL_SPRING |
Character(1) |
VARCHAR2(1) NOT NULL |
Enroll Plan for Spring
1=Full Time
2=3/4 Time
3=1/2 Time
4=LT 1/2 Time
5=Not Attending
|
| 27 |
ENROLL_NEXT_SUM |
Character(1) |
VARCHAR2(1) NOT NULL |
Enroll Plan for Next Sumr
1=Full Time
2=3/4 Time
3=1/2 Time
4=LT 1/2 Time
5=Not Attending
|
| 28 |
FATHER_GRADE_LVL |
Character(1) |
VARCHAR2(1) NOT NULL |
Father's Highest Grade Level
1=Middle School
2=High School
3=College
4=Unknown
|
| 29 |
MOTHER_GRADE_LVL |
Character(1) |
VARCHAR2(1) NOT NULL |
Mother's Highest Grade Level
1=Middle School
2=High School
3=College
4=Unknown
|
| 30 |
IWD_STATE_RES |
Character(2) |
VARCHAR2(2) NOT NULL |
State of Legal Residence
|
| 31 |
IWD_RES_PRIOR_94 |
Character(1) |
VARCHAR2(1) NOT NULL |
Legal Res Before 01-01-1994
|
| 32 |
IWD_RES_PRIOR |
Character(1) |
VARCHAR2(1) NOT NULL |
Legal Res Before 01-01-XXXX
|
| 33 |
IWD_LEGAL_RES_DT |
Character(6) |
VARCHAR2(6) NOT NULL |
Legal Residence Date
|
| 34 |
IWD_MALE |
Character(1) |
VARCHAR2(1) NOT NULL |
Are You Male
|
| 35 |
SEL_SERV_REGISTER |
Character(1) |
VARCHAR2(1) NOT NULL |
Permit Sel Serv to Enroll
1=Yes
2=No
|
| 36 |
DEGREE_CERTIF |
Character(1) |
VARCHAR2(1) NOT NULL |
Degree/Certificate
1=1st Bachelor Degree
2=2nd Bachelor Degree
3=Associate Degree (Occ/Tech)
4=Associate Degree (Gen Ed)
5=Certificate or Diploma < 2 yrs
6=Certificate or Diplome >= 2yrs
7=Teaching Credential
8=Graduate or Professional
9=Other/Undecided
|
| 37 |
IWD_GRADE_LVL |
Character(1) |
VARCHAR2(1) NOT NULL |
Grade Level
|
| 38 |
HS_GED_RCVD |
Character(1) |
VARCHAR2(1) NOT NULL |
HS Diploma or GED Received
1=Yes
2=No
|
| 39 |
FIRST_BACH_DEGREE |
Character(1) |
VARCHAR2(1) NOT NULL |
Received First Bachelor Degree
1=Yes
2=No
|
| 40 |
INTERESTED_IN_SL |
Character(1) |
VARCHAR2(1) NOT NULL |
Interested In Student Loans
1=Yes
2=No
|
| 41 |
INTERESTED_IN_WS |
Character(1) |
VARCHAR2(1) NOT NULL |
Interested In Work-Study
1=Yes
2=No
3=Don't Know
|
| 42 |
NUM_MONTH_VET_BEN |
Character(2) |
VARCHAR2(2) NOT NULL |
VA Ben Number of Months
|
| 43 |
IWD_MTHLY_VET_BEN |
Character(4) |
VARCHAR2(4) NOT NULL |
Monthly Veterans Benefits
|
| 44 |
IWD_TAX_RTN_FILED |
Character(1) |
VARCHAR2(1) NOT NULL |
Tax Return Filed?
|
| 45 |
TAX_FORM_FILED |
Character(1) |
VARCHAR2(1) NOT NULL |
Tax Form Filed
1=Completed 1040A/EZ
2=Completed 1040
3=Estimated 1040A/EZ
4=Estimated 1040
5=Will Not File
|
| 46 |
IWD_ELIG_1040A_EZ |
Character(1) |
VARCHAR2(1) NOT NULL |
Eligible For 1040A or EZ
|
| 47 |
IWD_STU_AGI |
Character(7) |
VARCHAR2(7) NOT NULL |
Student AGI
|
| 48 |
IWD_STU_TAX_PAID |
Character(10) |
VARCHAR2(10) NOT NULL |
Student Income Tax Paid
|
| 49 |
IWD_STU_NBR_EXEMP |
Character(2) |
VARCHAR2(2) NOT NULL |
Number of Exemptions
|
| 50 |
IWD_STU_EIC |
Character(10) |
VARCHAR2(10) NOT NULL |
Student EIC
|
| 51 |
IWD_STU_WORK_INC |
Character(10) |
VARCHAR2(10) NOT NULL |
Student Income From Work
|
| 52 |
IWD_SPS_WORK_INC |
Character(10) |
VARCHAR2(10) NOT NULL |
Spouse Income From Work
|
| 53 |
IWD_STU_WK_A |
Character(5) |
VARCHAR2(5) NOT NULL |
Student's Total from WK A
|
| 54 |
IWD_STU_WK_B |
Character(8) |
VARCHAR2(8) NOT NULL |
Student's Total from WK B
|
| 55 |
IWD_STU_CASH |
Character(10) |
VARCHAR2(10) NOT NULL |
Cash and Savings
|
| 56 |
IWD_STU_INVEST |
Character(10) |
VARCHAR2(10) NOT NULL |
Student's Investment Net Worth
|
| 57 |
IWD_STU_BUS_WORTH |
Character(10) |
VARCHAR2(10) NOT NULL |
Student's Business Net Worth
|
| 58 |
IWD_STU_FARM_WORTH |
Character(6) |
VARCHAR2(6) NOT NULL |
Farm Net Worth
|
| 59 |
IWD_BORN_PRIOR_76 |
Character(1) |
VARCHAR2(1) NOT NULL |
Born Before 01-01-1976
|
| 60 |
IWD_BORN_PRIOR |
Character(1) |
VARCHAR2(1) NOT NULL |
Born Before 01-01-XXXX
|
| 61 |
GRADUATE_STUDENT |
Character(1) |
VARCHAR2(1) NOT NULL |
Grad Student
1=Yes
2=No
|
| 62 |
MARRIED |
Character(1) |
VARCHAR2(1) NOT NULL |
Student Married
1=Yes
2=No
|
| 63 |
ORPHAN |
Character(1) |
VARCHAR2(1) NOT NULL |
Orphan or Ward of the Court
1=Yes
2=No
N=No
Y=Yes
|
| 64 |
VETERAN |
Character(1) |
VARCHAR2(1) NOT NULL |
Veteran
1=Yes
2=No
N=No
Y=Yes
|
| 65 |
DEPENDENTS |
Character(1) |
VARCHAR2(1) NOT NULL |
Dependents Other Than Spouse
1=Yes
2=No
N=No
Y=Yes
|
| 66 |
IWD_STU_FAM_MEM |
Character(2) |
VARCHAR2(2) NOT NULL |
Student Family Members
|
| 67 |
IWD_STU_MEM_COLL |
Character(2) |
VARCHAR2(2) NOT NULL |
Nbr in College
|
| 68 |
IWD_TAX_RTN_PAR |
Character(1) |
VARCHAR2(1) NOT NULL |
Tax Return Filed ?
|
| 69 |
IWD_TAX_FORM_PAR |
Character(1) |
VARCHAR2(1) NOT NULL |
Tax Form Filed
|
| 70 |
IWD_ELIG_1040A_PAR |
Character(1) |
VARCHAR2(1) NOT NULL |
Eligible For 1040A or EZ
|
| 71 |
IWD_PAR_AGI |
Character(7) |
VARCHAR2(7) NOT NULL |
Parent AGI
|
| 72 |
IWD_PAR_TAX_PAID |
Character(10) |
VARCHAR2(10) NOT NULL |
Income Tax Paid
|
| 73 |
IWD_PAR_NBR_EXEMP |
Character(2) |
VARCHAR2(2) NOT NULL |
Number of Exemptions
|
| 74 |
IWD_PAR_EIC |
Character(10) |
VARCHAR2(10) NOT NULL |
Earned Income Credit
|
| 75 |
IWD_FATH_WORK_INC |
Character(7) |
VARCHAR2(7) NOT NULL |
Father Income From Work
|
| 76 |
IWD_MOM_WORK_INC |
Character(7) |
VARCHAR2(7) NOT NULL |
Mother Income From Work
|
| 77 |
IWD_PAR_WK_A |
Character(5) |
VARCHAR2(5) NOT NULL |
Total from WK A
|
| 78 |
IWD_PAR_WK_B |
Character(8) |
VARCHAR2(8) NOT NULL |
Total from WK B
|
| 79 |
IWD_PAR_CASH |
Character(7) |
VARCHAR2(7) NOT NULL |
Cash and Savings
|
| 80 |
IWD_PAR_INVEST |
Character(7) |
VARCHAR2(7) NOT NULL |
Investment Net Worth
|
| 81 |
IWD_PAR_BUS_WORTH |
Character(7) |
VARCHAR2(7) NOT NULL |
Business Net Worth
|
| 82 |
IWD_PAR_FARM_WORTH |
Character(6) |
VARCHAR2(6) NOT NULL |
Farm Net Worth
|
| 83 |
IWD_PAR_MAR_STAT |
Character(1) |
VARCHAR2(1) NOT NULL |
Marital Status
|
| 84 |
IWD_PAR_FAM_MEM |
Character(2) |
VARCHAR2(2) NOT NULL |
Parent Family Members
|
| 85 |
IWD_PAR_MEM_COLL |
Character(1) |
VARCHAR2(1) NOT NULL |
Nbr in College
|
| 86 |
IWD_PAR_STATE_RES |
Character(2) |
VARCHAR2(2) NOT NULL |
State of Legal Residence
|
| 87 |
IWD_PAR_RES_PRI_94 |
Character(1) |
VARCHAR2(1) NOT NULL |
Legal Res Before 01-01-1994
|
| 88 |
IWD_PAR_RES_PRI |
Character(1) |
VARCHAR2(1) NOT NULL |
Legal Res Before 01-01-XXXX
|
| 89 |
IWD_PAR_RES_DT |
Character(6) |
VARCHAR2(6) NOT NULL |
Legal Residence Date
|
| 90 |
AGE_OLDER_PARENT |
Character(2) |
VARCHAR2(2) NOT NULL |
Age of Older Parent
|
| 91 |
SCHOOL_CHOICE_1 |
Character(6) |
VARCHAR2(6) NOT NULL |
Student's 1st Choice School
|
| 92 |
HOUSING_CODE_1 |
Character(1) |
VARCHAR2(1) NOT NULL |
Student's Housing Code Col 1
1=On-Campus
2=Off-Campus
3=Parents
|
| 93 |
SCHOOL_CHOICE_2 |
Character(6) |
VARCHAR2(6) NOT NULL |
Student's 2nd Choice School
|
| 94 |
HOUSING_CODE_2 |
Character(1) |
VARCHAR2(1) NOT NULL |
Student's Housing Code Col 2
1=On-Campus
2=Off-Campus
3=Parents
|
| 95 |
SCHOOL_CHOICE_3 |
Character(6) |
VARCHAR2(6) NOT NULL |
Student's 3rd Choice School
|
| 96 |
HOUSING_CODE_3 |
Character(1) |
VARCHAR2(1) NOT NULL |
Student's Housing Code Col 3
1=On-Campus
2=Off-Campus
3=Parents
|
| 97 |
SCHOOL_CHOICE_4 |
Character(6) |
VARCHAR2(6) NOT NULL |
Student's 4th Choice School
|
| 98 |
HOUSING_CODE_4 |
Character(1) |
VARCHAR2(1) NOT NULL |
Student's Housing Code Col 4
1=On-Campus
2=Off-Campus
3=Parents
|
| 99 |
SCHOOL_CHOICE_5 |
Character(6) |
VARCHAR2(6) NOT NULL |
Student's 5th Choice School
|
| 100 |
HOUSING_CODE_5 |
Character(1) |
VARCHAR2(1) NOT NULL |
Student's Housing Code Col 5
1=On-Campus
2=Off-Campus
3=Parents
|
| 101 |
SCHOOL_CHOICE_6 |
Character(6) |
VARCHAR2(6) NOT NULL |
Student's 6th Choice School
|
| 102 |
HOUSING_CODE_6 |
Character(1) |
VARCHAR2(1) NOT NULL |
Student's Housing Code Col 6
1=On-Campus
2=Off-Campus
3=Parents
|
| 103 |
DT_APP_COMPLETED |
Date(10) |
DATE |
Date Application Completed
|
| 104 |
IWD_APP_SIGNED_BY |
Character(1) |
VARCHAR2(1) NOT NULL |
FAFSA Signed by
|
| 105 |
IWD_PREP_SSN |
Character(9) |
VARCHAR2(9) NOT NULL |
Preparers SSN
|
| 106 |
IWD_PREP_EIN |
Character(9) |
VARCHAR2(9) NOT NULL |
Preparers EIN
|
| 107 |
IWD_PREP_SIGNATURE |
Character(1) |
VARCHAR2(1) NOT NULL |
Preparers Signature
|
| 108 |
DEPNDNCY_OVERRIDE |
Character(1) |
VARCHAR2(1) NOT NULL |
Dependency Override Indicator
1=Dependent To Independent
2=Cancel Dep Override-Corr Only
3=Override Failed
4=Homeless Youth Determination
|
| 109 |
FAA_INSTITUT_NUM |
Character(6) |
VARCHAR2(6) NOT NULL |
FAA Institution Nbr
|
| 110 |
FAA_SIGNATURE |
Character(1) |
VARCHAR2(1) NOT NULL |
FAA Signature
1=Signed
|
| 111 |
TRANS_RECEIPT_DT |
Date(10) |
DATE |
Transaction Receipt Date
|
| 112 |
IWD_RECORD_TYPE |
Character(1) |
VARCHAR2(1) NOT NULL |
Record Type
7=PIN Request
A=Initial Applications
C=Corrections/Duplicates
F=FDR Request
H=Corrections/Duplicate Req
R=Renewal Applications
S=Signature Corrections
|
| 113 |
IWD_SERIAL_NO |
Character(5) |
VARCHAR2(5) NOT NULL |
Current Serial Number
|
| 114 |
IWD_EARLY_ANALYSIS |
Character(1) |
VARCHAR2(1) NOT NULL |
Early Analysis Flag
|
| 115 |
RAPP_SSN |
Character(9) |
VARCHAR2(9) NOT NULL |
RAPP SSN
|
| 116 |
RAPP_NAME_ID |
Character(2) |
VARCHAR2(2) NOT NULL |
RAPP Name ID
|
| 117 |
IWD_ELEC_APP_SOURC |
Character(1) |
VARCHAR2(1) NOT NULL |
Electronic App Entry Source
2=FAA Entry
3=Easy FAFSA
4=FAFSA Express Diskette
5=FAFSA Web Download
6=Spanish - FOTW
7=Renewal FOTW
8=English FOTW
9=FAA Access
|
| 118 |
IWD_APP_VERSION_NO |
Character(6) |
VARCHAR2(6) NOT NULL |
Electronic App Version No.
|
| 119 |
IWD_ETI_DEST_CODE |
Character(7) |
VARCHAR2(7) NOT NULL |
ETI Destination Code
|
| 120 |
REJ_OVR_IND_STDNT |
Character(1) |
VARCHAR2(1) NOT NULL |
Student Independnt Status
1=Yes
2=No
|
| 121 |
REJ_OVR_STDNT_NAME |
Character(1) |
VARCHAR2(1) NOT NULL |
Student First/Last Name
1=Yes
2=No
|
| 122 |
REJ_OVR_BIG_FAMILY |
Character(1) |
VARCHAR2(1) NOT NULL |
Large Family Size
1=Yes
2=No
|
| 123 |
IWD_ASSUM_OVER_1 |
Character(1) |
VARCHAR2(1) NOT NULL |
Assumption Override 1
|
| 124 |
IWD_ASSUM_OVER_2 |
Character(1) |
VARCHAR2(1) NOT NULL |
Assumption Override 2
|
| 125 |
IWD_ASSUM_OVER_3 |
Character(1) |
VARCHAR2(1) NOT NULL |
Assumption Override 3
|
| 126 |
IWD_ASSUM_OVER_4 |
Character(1) |
VARCHAR2(1) NOT NULL |
Assumption Override 4
|
| 127 |
IWD_ASSUM_OVER_5 |
Character(1) |
VARCHAR2(1) NOT NULL |
Assumption Override 5
|
| 128 |
IWD_ASSUM_OVER_6 |
Character(1) |
VARCHAR2(1) NOT NULL |
Assumption Override 6
|
| 129 |
IWD_ASSUM_OVER_7 |
Character(1) |
VARCHAR2(1) NOT NULL |
Assumption Override 7
|
| 130 |
DRUG_OFFENSE_CONV |
Character(1) |
VARCHAR2(1) NOT NULL |
Drug Offense Conviction
1=Eligible
2=Partially Eligible
3=Ineligible or Don't know
I=Institutional Override
|
| 131 |
FATHER_SSN |
Character(9) |
VARCHAR2(9) NOT NULL |
Father's SSN
|
| 132 |
FATHER_LAST_NAME |
Character(16) |
VARCHAR2(16) NOT NULL |
Father's Last Name
|
| 133 |
MOTHER_SSN |
Character(9) |
VARCHAR2(9) NOT NULL |
Mother's SSN
|
| 134 |
MOTHER_LAST_NAME |
Character(16) |
VARCHAR2(16) NOT NULL |
Mother's Last Name
|
| 135 |
IWD_MODEL |
Character(1) |
VARCHAR2(1) NOT NULL |
Model
|
| 136 |
IWD_STU_WK_C |
Character(8) |
VARCHAR2(8) NOT NULL |
Student's Total from WK C
|
| 137 |
CHILDREN |
Character(1) |
VARCHAR2(1) NOT NULL |
Have Children you support
1=Yes
2=No
|
| 138 |
IWD_PAR_WK_C |
Character(8) |
VARCHAR2(8) NOT NULL |
Parent's Total from WK C
|
| 139 |
IWD_REJECT_OVRD_B |
Character(1) |
VARCHAR2(1) NOT NULL |
Reject Override B
|
| 140 |
IWD_REJECT_OVRD_N |
Character(1) |
VARCHAR2(1) NOT NULL |
Reject Override N
|
| 141 |
IWD_REJECT_OVRD_W |
Character(1) |
VARCHAR2(1) NOT NULL |
Reject Override W
|
| 142 |
IWD_STD_EMAIL |
Character(50) |
VARCHAR2(50) NOT NULL |
Student's Email Address
|