INSTALLATION_FA(SQL Table) |
Index Back |
|---|---|
Financial Aid Installation Tbl |
| # | PeopleSoft Field Name | PeopleSoft Field Type | Database Column Type | Description |
|---|---|---|---|---|
| 1 | LN_SEQ_NBR_CL_LAST | Number(8,0) | INTEGER NOT NULL |
Last Commonline Seq Num Assgn
Default Value: 10000000 |
| 2 | DIRECT_LEND_ACTV | Character(1) | VARCHAR2(1) NOT NULL |
Direct Lending Activiation
Y/N Table Edit Default Value: N |
| 3 | COMMONLN_ACTV | Character(1) | VARCHAR2(1) NOT NULL |
CommonLine Activation
Y/N Table Edit Default Value: N |
| 4 | LOAN_DISB_DELAY | Character(1) | VARCHAR2(1) NOT NULL |
Freshman Loan 30 Day Delay
Y/N Table Edit Default Value: Y |
| 5 | LN_BATCH_SEQ_LAST | Character(2) | VARCHAR2(2) NOT NULL |
Last Loan Batch Sequence
Default Value: 00 |
| 6 | LN_BATCH_SEQ_DT | Date(10) | DATE | Loan Batch Seq Nbr Date |
| 7 | INAS_RULE_SET | Character(4) | VARCHAR2(4) NOT NULL |
INAS Rule Set
BASE=CSS Rules/Values HLTH=Health Professional STD=Undergrad/Graduate |
| 8 | BASE_WEEKS_ACAD | Number(4,1) | DECIMAL(3,1) NOT NULL | Academic Base Weeks |
| 9 | BASE_WEEKS_NSTD | Number(4,1) | DECIMAL(3,1) NOT NULL | Non-Standard Base Weeks |
| 10 | PKG_SEQ_NO_BATCH | Number(8,0) | INTEGER NOT NULL | Last Packaging Batch Nbr |
| 11 | DFLT_PELL_AWD_RULE | Character(1) | VARCHAR2(1) NOT NULL |
Aded values for Auto package Pell Calculation
C=Enrollment Current Load E=Enrollment FA Load F=Full Time H=Half Time Default Value: E |
| 12 | AWARD_BATCH_ID | Number(11,0) | DECIMAL(11) NOT NULL | Last Award Batch ID |
| 13 | BKG_ERRS_ALLOWD | Number(5,0) | INTEGER NOT NULL |
Background Errors Allowed
Default Value: 1 |
| 14 | COMMIT_LEVEL | Number(5,0) | INTEGER NOT NULL | Commit Level |
| 15 | FA_GAP_ITEM_TYPE | Character(12) | VARCHAR2(12) NOT NULL | GAP Item Type |
| 16 | PKG_DATA_SOURCE | Character(1) | VARCHAR2(1) NOT NULL |
Packaging Data Source tells the Packaging Controller to use Federal Application vs. Institutional Application data for packaging awards.
1=Federal Data Only 2=Institutional Data Only 3=Federal 1st, Institutional 2nd 4=Institutional 1st, Federal 2nd Default Value: 1 |
| 17 | INST_APP_SOURCE | Character(1) | VARCHAR2(1) NOT NULL |
Application Source
0=Need Access 1=Electronic Initial Application 2=Renewal Application 3=Electronic Correction 4=FAFSA Express 5=ACT 6=I-NET 7=NCS 8=Profile 9=Institutional Application O=FT Canada Student Loan P=PT Canada Student Loan Default Value: 8 |
| 18 | PELL_JIT | Character(1) | VARCHAR2(1) NOT NULL |
Pell Just In Time Institution
Y/N Table Edit Default Value: N |
| 19 | DISB_IF_ACKN | Character(1) | VARCHAR2(1) NOT NULL |
Disburse only if Acknowledged
Y/N Table Edit Default Value: N |
| 20 | LN_ORIG_OFFR_SW | Character(1) | VARCHAR2(1) NOT NULL |
Loan Originate on Offer Sw
Y/N Table Edit Default Value: N |
| 21 | LN_FFELP_MPN_SW | Character(1) | VARCHAR2(1) NOT NULL |
FFELP Serial MPN Switch
Y/N Table Edit Default Value: N |
| 22 | CNAS_FM_RULE_SET | Character(4) | VARCHAR2(4) NOT NULL | CNAS FM Rule Set |
| 23 | CNAS_IM_RULE_SET | Character(4) | VARCHAR2(4) NOT NULL | CNAS IM Rule Set |
| 24 | FA_AUDIT_FATERM | Character(1) | VARCHAR2(1) NOT NULL |
Audit FATerm Build
Y/N Table Edit Default Value: Y |
| 25 | PELL_CALC_START | Character(1) | VARCHAR2(1) NOT NULL |
Pell Calculation Start
C=Enrollment Current Load E=Enrollment FA Load F=Full Time H=Half Time Default Value: E |
| 26 | PELL_CALC_MIDTERM | Character(1) | VARCHAR2(1) NOT NULL |
Pell Calculation Midterm
C=Enrollment Current Load E=Enrollment FA Load F=Full Time H=Half Time Default Value: E |
| 27 | PELL_CALC_CENSUS | Character(1) | VARCHAR2(1) NOT NULL |
Pell Calculation Census
C=Enrollment Current Load E=Enrollment FA Load F=Full Time H=Half Time Default Value: E |
| 28 | PELL_NBR_TERMS | Number(2,0) | SMALLINT NOT NULL | Pell Number of Terms |
| 29 | LAST_FORM_PROCINST | Number(31,0) | DECIMAL(31) NOT NULL | Last Form Process Instance holds the last 'FORM_PROC_INST' that was used, so that it can be incremented by 1 when it is next used. |
| 30 | SFA_AGGR_SRC_DFLT | Character(1) | VARCHAR2(1) NOT NULL |
FA-Aggregate Source default value
N=NSLDS Total P=PS Aggregates Default Value: P |
| 31 | SFA_CR_LAST_DATE | Date(10) | DATE | Used by FAPLORG0.CBL to store the last CRC/CL Origination Date, used in creation of LN_APPL_ID. |
| 32 | SFA_CR_SYSTEM_ID | Number(2,0) | SMALLINT NOT NULL | CRC System ID. Used as part of LN_APPL_ID. |
| 33 | SFA_EA_TRANS_NBR | Number(15,0) | DECIMAL(15) NOT NULL | Transaction number used for staging external awards to the database. |
| 34 | SFA_LN_CNSL_VER | Character(1) | VARCHAR2(1) NOT NULL |
Loan Counseling Version
1=Self Service 2=Administrative Default Value: 2 |
| 35 | SFA_GLOBAL | Character(1) | VARCHAR2(1) NOT NULL |
Do Not use PKG Data Source
Y/N Table Edit Default Value: N |