| # |
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 |
NSLDS_HEADER_NBR |
Number(3,0) |
SMALLINT NOT NULL |
NSLDS Header Nbr
|
| 5 |
NSLDS_REC_TYPE |
Character(1) |
VARCHAR2(1) NOT NULL |
NSLDS Record Type Ind
|
| 6 |
NSLDS_DTL_NBR |
Number(6,0) |
INTEGER NOT NULL |
NSLDS Detail Nbr
|
| 7 |
SSN |
Character(9) |
VARCHAR2(9) NOT NULL |
Social Security #
|
| 8 |
LN_STG_PROC_STAT |
Character(1) |
VARCHAR2(1) NOT NULL |
Loan Staging Record Proc Stat
E=Error
K=Skipped
L=Loaded
N=Not Processed
S=Skip
U=Unprocessed
X=Suspended
Y=Processed
Default Value: U
|
| 9 |
PROCESS_INSTANCE |
Number(10,0) |
DECIMAL(10) NOT NULL |
Process Instance
|
| 10 |
LN_STG_ERR_CODE |
Character(1) |
VARCHAR2(1) NOT NULL |
Load Staging Error Code
C=Invalid SSN Encountered
D=EFFDT conflict
M=Multiple matches
S=Student not found
|
| 11 |
EMPLID |
Character(11) |
VARCHAR2(11) NOT NULL |
Employee ID
Prompt Table:
PEOPLE_SRCH
Set Control Field: EMPLID
|
| 12 |
NSLDS_REVIEW_STAT |
Character(1) |
VARCHAR2(1) NOT NULL |
Alert Record Review Status
Y/N Table Edit
Default Value: N
|
| 13 |
NSLDS_FIRST_NAME |
Character(12) |
VARCHAR2(12) NOT NULL |
First Name
|
| 14 |
NSLDS_LAST_NAME |
Character(35) |
VARCHAR2(35) NOT NULL |
Last Name
|
| 15 |
NSLDS_DOB |
Date(10) |
DATE |
NSLDS Date of Birth
|
| 16 |
CPS_SCHOOL_CODE |
Character(6) |
VARCHAR2(6) NOT NULL |
CPS School Code. Also known as Title IV School Code
|
| 17 |
INSTIT_OE_BR |
Character(2) |
VARCHAR2(2) NOT NULL |
Institution OE Branch
|
| 18 |
NSLDS_FIRST_NM_INF |
Character(12) |
VARCHAR2(12) NOT NULL |
The student's first name that was submitted to NSLDS either through the Inform file or through the NSLDS web page. This name may not match the name in the school database.
|
| 19 |
NSLDS_LAST_NM_INF |
Character(35) |
VARCHAR2(35) NOT NULL |
The student's last name that was submitted to NSLDS either through the Inform file or through the NSLDS web page. This name may not match the name in the school database.
|
| 20 |
NSLDS_DOB_INFORM_O |
Character(8) |
VARCHAR2(8) NOT NULL |
The student's date of birth that was submitted to NSLDS either through the Inform file or through the NSLDS web page. This DOB may not match the DOB in the school database.
|
| 21 |
NSLDS_UPDT_SOURCE |
Character(1) |
VARCHAR2(1) NOT NULL |
NSLDS Transaction Source
A=NSLDS Alert File
F=Financial Aid Transcript
H=NSLDS FA History File
I=ISIR
M=Manual
Default Value: A
|
| 22 |
NSLDS_DFLT_LOAN |
Character(1) |
VARCHAR2(1) NOT NULL |
NSLDS Default Reported
Y/N Table Edit
|
| 23 |
NSLDS_DSCHRGD_LOAN |
Character(1) |
VARCHAR2(1) NOT NULL |
NSLDS Discharged Rptd
C=Conditional
D=Death
M=Multiple
N=None
P=Permanent
R=Reaffirmed
Y=Yes
Y/N Table Edit
|
| 24 |
NSLDS_SATIS_RPYMNT |
Character(1) |
VARCHAR2(1) NOT NULL |
NSLDS Satisfctry Rpymnt
Y/N Table Edit
|
| 25 |
NSLDS_ACTV_BNKRPTC |
Character(1) |
VARCHAR2(1) NOT NULL |
NSLDS Active Bankruptcy
Y/N Table Edit
|
| 26 |
NSLDS_AGGR_SUB_O |
Character(6) |
VARCHAR2(6) NOT NULL |
NSLDS Aggregate Subsidized
|
| 27 |
NSLDS_AGGR_UNSUB_O |
Character(6) |
VARCHAR2(6) NOT NULL |
NSLDS Aggregate Unsubsidized
|
| 28 |
NSLDS_AGGR_CMBO_CH |
Character(6) |
VARCHAR2(6) NOT NULL |
Aggr Combined Out Principal
|
| 29 |
NSLDS_AGGR_CNSL_O |
Character(6) |
VARCHAR2(6) NOT NULL |
NSLDS Aggregate Consolidated
|
| 30 |
PEND_AGGR_SUB_O |
Character(6) |
VARCHAR2(6) NOT NULL |
NSLDS Pending Aggr Sub
|
| 31 |
PEND_AGGR_UNSUB_O |
Character(6) |
VARCHAR2(6) NOT NULL |
NSLDS Pending Aggr Unsub
|
| 32 |
NSLDS_AGGR_PCOMBCH |
Character(6) |
VARCHAR2(6) NOT NULL |
Aggr Combined Pending Disbt
|
| 33 |
AGGR_SUB_TOT_O |
Character(6) |
VARCHAR2(6) NOT NULL |
NSLDS Tot Aggr Sub
|
| 34 |
AGGR_UNSUB_TOT_O |
Character(6) |
VARCHAR2(6) NOT NULL |
NSLDS Tot Aggr Unsub
|
| 35 |
NSLDS_AGGR_COMB_CH |
Character(6) |
VARCHAR2(6) NOT NULL |
Aggregate Combined Total
|
| 36 |
AGGR_CONSL_TOT_O |
Character(6) |
VARCHAR2(6) NOT NULL |
Aggregate Consolidated Total
|
| 37 |
NSLDS_AGGR_PERK_O |
Character(6) |
VARCHAR2(6) NOT NULL |
NSLDS Aggregate Perkins
|
| 38 |
NSLDS_YTD_PERK_O |
Character(6) |
VARCHAR2(6) NOT NULL |
NSLDS Year-to-Date Perkins
|
| 39 |
IWD_DL_MPN_FLAG |
Character(1) |
VARCHAR2(1) NOT NULL |
DL Master-Prom Note Flag
|
| 40 |
NSLDS_PELL_CHNG |
Character(1) |
VARCHAR2(1) NOT NULL |
NSLDS Pell change flag indicates that a changed Pell Grant record is contained in the NSLDS alert file.
Y/N Table Edit
|
| 41 |
NSLDS_LOAN_CHNG |
Character(1) |
VARCHAR2(1) NOT NULL |
NSLDS Loan change flag indicates that a changed loan record is contained in the NSLDS alert file.
Y/N Table Edit
|
| 42 |
NSLDS_AGGR_CHNG |
Character(1) |
VARCHAR2(1) NOT NULL |
NSLDS Aggregate change flag indicates that new aggregate information is contained in the NSLDS alert file.
Y/N Table Edit
|
| 43 |
NSLDS_PLUS_MPN_FLG |
Character(1) |
VARCHAR2(1) NOT NULL |
DL Plus Master-Prom Note Flag
A=Active
C=Closed
E=Inactive,Endorsed
I=Inactive
N=No MPN on file
U=Unavailable
|
| 44 |
NSLDS_SUB_EXCEEDED |
Character(1) |
VARCHAR2(1) NOT NULL |
NSLDS Sub Limit Exceeded
Y/N Table Edit
|
| 45 |
NSLDS_CMB_EXCEEDED |
Character(1) |
VARCHAR2(1) NOT NULL |
NSLDS Combo Limit Exceeded
Y/N Table Edit
|
| 46 |
NSLDS_AG_CU_OPB_CH |
Character(6) |
VARCHAR2(6) NOT NULL |
NSLDS Aggr Cons Unallocated
|
| 47 |
NSLDS_AGGR_PLUS_CH |
Character(6) |
VARCHAR2(6) NOT NULL |
NSLDS Aggregate PLUS
|
| 48 |
NSLDS_AG_CU_TOT_CH |
Character(6) |
VARCHAR2(6) NOT NULL |
NSLDS Constd Total Unallocated
|
| 49 |
NSLDS_PLUS_TOT_CH |
Character(6) |
VARCHAR2(6) NOT NULL |
NSLDS Aggregate PLUSTotal
|
| 50 |
SFA_ACG_PAY_CHG |
Character(1) |
VARCHAR2(1) NOT NULL |
ACG Payment Change
|
| 51 |
SFA_NSG_CHG |
Character(1) |
VARCHAR2(1) NOT NULL |
NSLDS NSG Change
|
| 52 |
SFA_GPLUS_MPNFLG |
Character(1) |
VARCHAR2(1) NOT NULL |
DL GradPlus MPN Flag
A=Active
C=Closed
E=Inactive,Endorsed
I=Inactive
N=No Master
U=Unavailable
|
| 53 |
SFA_FRAUD_FLG |
Character(1) |
VARCHAR2(1) NOT NULL |
Fraud Flag
|
| 54 |
SFA_AGGR_GPLUS_CH |
Character(6) |
VARCHAR2(6) NOT NULL |
NSLDS Aggr Grad Plus
|
| 55 |
SFA_GPLUS_TOT_CH |
Character(6) |
VARCHAR2(6) NOT NULL |
NSLDS Grad Plus Total
|
| 56 |
SFA_NSLDS_UGSUB_LN |
Character(1) |
VARCHAR2(1) NOT NULL |
NSLDS UG Sub Loan Limit
C=Close to Limit
E=Exceeded Limit
N=No Problem
R=Exceeded Limit/Reaffirmed Debt
|
| 57 |
SFA_NSLDS_UGCMB_LN |
Character(1) |
VARCHAR2(1) NOT NULL |
NSLDS UG Combo Loan Limit
C=Close to Limit
E=Exceeded Limit
N=No Problem
R=Exceeded Limit/Reaffirmed Debt
|
| 58 |
ISIR_SUB_LIMIT_FLG |
Character(1) |
VARCHAR2(1) NOT NULL |
ISIR Sub Limit Flag
C=Close to Limit
E=Exceeded Limit
N=No Problem
R=Exceeded Limit/Reaffirmed Debt
|
| 59 |
ISIR_CMB_LIMIT_FLG |
Character(1) |
VARCHAR2(1) NOT NULL |
ISIR Combo Limit Flag
C=Close to Limit
E=Exceeded Limit
N=No Problem
R=Exceeded Limit/Reaffirmed Debt
|
| 60 |
SFA_TCH_LN_CNV_FLG |
Character(1) |
VARCHAR2(1) NOT NULL |
TEACH Grant Loan Conv
1=Yes
2=No
|
| 61 |
SFA_TCH_LN_BALANCE |
Character(6) |
VARCHAR2(6) NOT NULL |
Loan Principal Balance
|
| 62 |
SFA_TCH_LOAN_TOTAL |
Character(6) |
VARCHAR2(6) NOT NULL |
Loan Total
|
| 63 |
SFA_TCH_UGRD_AMNT |
Character(6) |
VARCHAR2(6) NOT NULL |
UG Disbursement Amount
|
| 64 |
SFA_TCH_GRAD_AMNT |
Character(6) |
VARCHAR2(6) NOT NULL |
Graduate Disbursement Amount
|
| 65 |
SFA_TCH_GRNT_CHG |
Character(1) |
VARCHAR2(1) NOT NULL |
TEACH Grant Change Flag
|
| 66 |
SFA_TCH_UG_PCTUSD |
Number(8,4) |
DECIMAL(7,4) NOT NULL |
UGRD Percent Elig Used
|
| 67 |
SFA_TCH_UG_R_AMT |
Character(6) |
VARCHAR2(6) NOT NULL |
UG Remaining Amount
|
| 68 |
SFA_TCH_GRD_PCTUSD |
Number(8,4) |
DECIMAL(7,4) NOT NULL |
GRAD Percent Elig Used
|
| 69 |
SFA_TCH_GRD_R_AMT |
Character(6) |
VARCHAR2(6) NOT NULL |
Grad Remaining Amount
|
| 70 |
SFA_TCH_AGGR_GR_CH |
Character(1) |
VARCHAR2(1) NOT NULL |
NSLDS TEACH Grant Aggr Chg
|
| 71 |
SFA_TCH_AGGR_LN_CH |
Character(1) |
VARCHAR2(1) NOT NULL |
NSLDS TEACH Loan Aggr Chg
|
| 72 |
SFA_UG_AGR_SUB_O |
Character(6) |
VARCHAR2(6) NOT NULL |
UG Aggregate Subsidized
|
| 73 |
SFA_UG_AGR_USUB_O |
Character(6) |
VARCHAR2(6) NOT NULL |
UG Aggregate Unsubsidized
|
| 74 |
SFA_UG_AGR_CMB_O |
Character(6) |
VARCHAR2(6) NOT NULL |
UG Aggregate Combined
|
| 75 |
SFA_UG_AGR_CNSL_O |
Character(6) |
VARCHAR2(6) NOT NULL |
UG Aggregate Consolidated
|
| 76 |
SFA_UG_AGR_SB_PN_O |
Character(6) |
VARCHAR2(6) NOT NULL |
UG Subsidized Pending Disburse
|
| 77 |
SFA_UG_AGR_USB_PNO |
Character(6) |
VARCHAR2(6) NOT NULL |
UG Unsub Pending Disbursement
|
| 78 |
SFA_UG_AGR_CMB_PNO |
Character(6) |
VARCHAR2(6) NOT NULL |
UG Combined Pending Disb
|
| 79 |
SFA_UG_AGGR_SUB_O |
Character(6) |
VARCHAR2(6) NOT NULL |
UG Total Aggregate Subsidized
|
| 80 |
SFA_UG_AGGR_USUB_O |
Character(6) |
VARCHAR2(6) NOT NULL |
UG Aggregate Unsub Total
|
| 81 |
SFA_UG_AGGR_CMB_O |
Character(6) |
VARCHAR2(6) NOT NULL |
UG Aggregate Combined Total
|
| 82 |
SFA_UG_AGGR_CNSL_O |
Character(6) |
VARCHAR2(6) NOT NULL |
UG Aggregate Consolidated
|
| 83 |
SFA_UG_AWARD_YR |
Character(4) |
VARCHAR2(4) NOT NULL |
UG Award Year
|
| 84 |
SFA_UG_DEP_IND |
Character(1) |
VARCHAR2(1) NOT NULL |
UG Dependency Indicator
D=Dependent
I=Independent
|
| 85 |
SFA_GR_AGR_SUB_O |
Character(6) |
VARCHAR2(6) NOT NULL |
Grad Aggregate Subsidized
|
| 86 |
SFA_GR_AGR_USUB_O |
Character(6) |
VARCHAR2(6) NOT NULL |
Grad Aggregate Unsubsidized
|
| 87 |
SFA_GR_AGR_CMB_O |
Character(6) |
VARCHAR2(6) NOT NULL |
Grad Aggregate Combined
|
| 88 |
SFA_GR_AGR_CNSL_O |
Character(6) |
VARCHAR2(6) NOT NULL |
Grad Aggregate Consolidated
|
| 89 |
SFA_GR_AGR_SB_PN_O |
Character(6) |
VARCHAR2(6) NOT NULL |
Grad Subsidized Pending Disb
|
| 90 |
SFA_GR_AGR_USB_PNO |
Character(6) |
VARCHAR2(6) NOT NULL |
Grad Unsub Pending Disb
|
| 91 |
SFA_GR_AGR_CMB_PNO |
Character(6) |
VARCHAR2(6) NOT NULL |
Grad Combined Pending Disb
|
| 92 |
SFA_GR_AGGR_SUB_O |
Character(6) |
VARCHAR2(6) NOT NULL |
Grad Total Aggregate Subsidize
|
| 93 |
SFA_GR_AGGR_USUB_O |
Character(6) |
VARCHAR2(6) NOT NULL |
Grad Aggregate Unsub Total
|
| 94 |
SFA_GR_AGGR_CMB_O |
Character(6) |
VARCHAR2(6) NOT NULL |
Grad Aggregate Combined Total
|
| 95 |
SFA_GR_AGGR_CNSL_O |
Character(6) |
VARCHAR2(6) NOT NULL |
Grad Aggregate Consolidated
|
| 96 |
SFA_GR_AWARD_YR |
Character(4) |
VARCHAR2(4) NOT NULL |
Graduate Award Year
|
| 97 |
SFA_GR_DEP_IND |
Character(1) |
VARCHAR2(1) NOT NULL |
Grad Dependency Indicator
D=Dependent
I=Independent
|
| 98 |
SFA_LIFETIME_ELIG |
Number(8,5) |
DECIMAL(7,5) NOT NULL |
Lifetime Eligibility Used
|
| 99 |
PROCESS_DT |
Date(10) |
DATE |
Process Date
|
| 100 |
MAX_MATCH_LEVEL |
Number(3,0) |
SMALLINT NOT NULL |
Max Search Match Level
|
| 101 |
ID_OVERRIDE |
Character(1) |
VARCHAR2(1) NOT NULL |
ID Override
N=No
Y=Yes
Default Value: N
|
| 102 |
SFA_NSLDS_SUSP_RSN |
Character(1) |
VARCHAR2(1) NOT NULL |
Suspend Reason
D=Effective Date Conflict
E=Effective Sequence Conflict
L=Data Load Parms Not Found
M=Multiple Matches Found
P=One Match Found
S=No Match Found
|
| 103 |
SFA_NSLDS_SKIP_RSN |
Character(1) |
VARCHAR2(1) NOT NULL |
Skip Reason
I=Multiple Matches Found
K=One Match Found
M=Manually Set to Skip/Done
S=No Match Found
|
| 104 |
SFA_NSLDS_LD_ACTN |
Character(1) |
VARCHAR2(1) NOT NULL |
NSLDS LOAD ACTION
A=Add NSLDS
I=Skip/Done
R=Recycle
|
| 105 |
SFA_NSLDS_ENRL_PTN |
Character(1) |
VARCHAR2(1) NOT NULL |
Unusual Enrollment Pattern Flg
1=Federal Student Aid Use Only
2=Possible Enrollment Problem
3=Questionable Enroll Pattern
N=No Unusual Enroll Pattern
|
| 106 |
SFA_NSLDS_PELL_LMT |
Character(1) |
VARCHAR2(1) NOT NULL |
NSLDS Pell Lifetime Limit
C=Close to Pell Limit
E=Met or Exceeded Pell Limit
H=High Pell Percent
N=No Problem
|
| 107 |
SFA_NSLDS_USE_LMT |
Character(1) |
VARCHAR2(1) NOT NULL |
NSLDS Sub Usage Limit Applies
N=No
Y=Yes
|
| 108 |
SFA_NSLDS_LN_ELIG |
Number(7,3) |
DECIMAL(6,3) NOT NULL |
Subsidized Usage Period
|
| 109 |
SFA_LIFETIME_IASG |
Number(8,5) |
DECIMAL(7,5) NOT NULL |
Lifetime Eligibility Used
|
| 110 |
SFA_NSLDS_IASG_LMT |
Character(1) |
VARCHAR2(1) NOT NULL |
NSLDS IASG Lifetime Limit
C=Close to Pell Limit
E=Met or Exceeded Pell Limit
H=High Pell Percent
N=No Problem
|
| 111 |
NSLDS_IASG_CHNG |
Character(1) |
VARCHAR2(1) NOT NULL |
NSLDS IASG change flag
|