Data Dictionary Links
Clicking the linked (blue) fields in any table will take you to the Data Dictionary and provide you with more information about that field as well as field values if they are available.
| Key | Record.Fieldname | Format | XLAT | Heading Text | Notes |
|---|---|---|---|---|---|
| → | ACAD_CAREER - Academic Career | Char4 | Career | ||
| ACCEPT_AMOUNT - Accept Amount | Num10.2 | Accepted | |||
| ACCEPT_LOAN_FEE - Accept Loan Fee | Num5.2 | Accept Loan Fee | |||
| ACCEPT_REBATE_AMT - Accept Rebate Amount | Num5.2 | Accept Rebate | |||
| → | AID_YEAR - Aid Year | Char4 | Aid Yr | ||
| AUTHORIZED_AMOUNT - Authorized Amount | Num10.2 | Authorized | |||
| AWARD_MSG_CD - Award Message | Char4 | Message | |||
| AWARD_PERIOD - Award Period | Char1 | N | Awd Period | ||
| AWARD_POSTED - Award Posted | Char1 | Posted | |||
| AWARD_STATUS - Award Status | Char1 | N | Status | ||
| CANCEL_DECLINE_AMT - Cancel/Decline Amount | Num10.2 | Cancel Amt | |||
| CHARGE_PRIORITY - Charge Priority List | Char8 | Charge Lst | |||
| CURRENCY_CD - Currency Code | Char3 | Currency | |||
| CUSTOM_LOAN_FEE - Custom Loan Fee | Char1 | Custom Loan Fee | |||
| DISBURSED_AMOUNT - Disbursed Amount | Num10.2 | Disbursed | |||
| DISBURSEMENT_PLAN - Disbursement Plan | Char2 | Disb Plan | Descriptions for the DISBURSEMENT_PLAN field can be found in the PS_DISB_PLAN_TBL and the detailed information is on the PS_DISB_ID_TBL. | ||
| → | EMPLID - Empl ID | Char11 | ID | ||
| FA_PROF_JUDGEMENT - Professional Judgement | Char1 | Prof Judgement | |||
| FIN_AID_TYPE - Fin Aid Type | Char4 | Finaid Typ | |||
| HIGHEST_ACCEPT_AMT - Highest Accepted | Num10.2 | High Accep | |||
| HIGHEST_OFFER_AMT - Highest Offer | Num10.2 | High Offer | |||
| → | INSTITUTION - Academic Institution | Char5 | Institution | ||
| → | ITEM_TYPE - Item Type | Char12 | Item Type | ||
| LN_DEST_FEE_PRCNT - Destination Loan Fee | SNm4.3 | Dest Loan Fee | |||
| LOAN_ADJUST_CD - Loan Adjust Reason | Char1 | Ln Reason | |||
| LOAN_TOT_DISB - Total Loan Disbursements | Num10.2 | Tot Disb | |||
| LOAN_TOT_ORIG - Total Loan Orig Amt | Num10.2 | Tot Orig | |||
| LOCK_AWARD_FLAG - Lock Award | Char1 | Lock Award | |||
| NET_AWARD_AMT - Net Award Amount | SNm11.2 | Net Award | |||
| NET_OFFER_AMT - Net Offer Amount | Num10.2 | Net Offer Amt | |||
| OFFER_ACTIVITY_IND - Offer Activity | Char1 | N | Offer Chg | ||
| OFFER_AMOUNT - Offer Amount | Num10.2 | Offered | |||
| OFFER_LOAN_FEE - Offer Loan Fee | Num5.2 | Offer Loan Fee | |||
| OFFER_REBATE_AMT - Offer Rebate Amount | Num5.2 | Offer Rebate | |||
| OVERRIDE_FL - Override Flag | Char1 | Override | |||
| OVERRIDE_NEED - Need Override Lock Flag | Char1 | Need Override | |||
| PKG_APP_DATA_USED - Application Data Used | Char1 | N | App Data Used | ||
| PKG_PLAN_ID - Packaging Plan ID | Char10 | Plan ID | |||
| PKG_SEQ_NBR - Sequence Nbr | Num5.0 | Sequence | |||
| PKG_STATUS_CD - Package Status | Num5.0 | Status | |||
| SCHEDULED_AWARD - Scheduled Award | Num10.2 | Scheduled | |||
| SETID - SetID | Char5 | SetID | |||
| SFA_AGGR_SRC_USED - Aggregate Source Used | Char1 | N | Aggregate Used | ||
| SFA_EA_INDICATOR - External Award | Char1 | EA | |||
| SFA_EA_LOAN_CERT - Loan Certification | Char1 | Loan Cert | |||
| SFA_EA_PROGRAM_CD - External Award Program Code | Char3 | Program Code | |||
| SFA_EA_SOURCE - External Award Source | Char3 | Source | |||
| SFA_EA_TYPE - External Award Type | Char3 | Award Type | |||
| SFA_PKG_DEP_STAT - Dependency Status | Char1 | N | Dependency | ||
| SFA_RPKG_PLAN_ID - Repackaging Plan ID | Char10 | RPKG Plan ID | |||
| SPLIT_CODE - Split Code | Char2 | Split Code | |||
| WS_ERND_TO_DT - Work Study Earned | Num10.2 | WS Earned |
