|
SELECT INSTITUTION , AID_YEAR , APP_SOURCE_CODE , EFFDT , EFF_STATUS , LVL_SUSPEND_RECORD , LVL_ADD_RECORD , UPDATE_NAME , SFA_UPDATE_ADDRESS , UPDATE_PERSONAL , ADDRESS_TYPE , EFC_SOURCE_IND , SM_PARM_CD , MAX_MATCH_LEVEL , USE_EFC_OVERRIDE ,SFA_PF_INAS_CALREQ ,SFA_PF_UPDAT_PHONE ,PHONE_TYPE , SFA_PF_SM_ACTION FROM PS_INST_LOAD_CNTRL WHERE APP_SOURCE_CODE = '0'
|
| # |
PeopleSoft Field Name |
PeopleSoft Field Type |
Database Column Type |
Description |
| 1 |
 INSTITUTION |
Character(5) |
VARCHAR2(5) NOT NULL |
Academic Institution
Default Value: OPR_DEF_TBL_CS.INSTITUTION
Prompt Table:
INSTITUTION_TBL
|
| 2 |
AID_YEAR |
Character(4) |
VARCHAR2(4) NOT NULL |
Aid Year
Default Value: 2010
Prompt Table:
INST_AID_YR_VW
|
| 3 |
APP_SOURCE_CODE |
Character(1) |
VARCHAR2(1) NOT NULL |
Application Source Code
0=Need Access
0=Need Access
1=Electronic Initial Application
2=Electronic Renewal Aplication
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: 0
|
| 4 |
EFFDT |
Date(10) |
DATE NOT NULL |
Effective Date
Default Value: %date
|
| 5 |
EFF_STATUS |
Character(1) |
VARCHAR2(1) NOT NULL |
Effective Status
A=Active
I=Inactive
Default Value: A
|
| 6 |
LVL_SUSPEND_RECORD |
Character(1) |
VARCHAR2(1) NOT NULL |
Student Status Suspend Level
0=0 - Anyone not loaded
1=1 - Recruit or higher
2=2 - Inactive Admits or higher
3=3 - Applicant or higher
4=4 - Admitted or higher
5=5 - Accepted/Continuing only
|
| 7 |
LVL_ADD_RECORD |
Character(1) |
VARCHAR2(1) NOT NULL |
Student Status Add Level
0=0 - Load everyone
1=1 - Recruits or higher
2=2 - Inactive admits or higher
3=3 - Applicants or higher
4=4 - Active admits or higher
5=5 - Accepted/Continuing only
|
| 8 |
UPDATE_NAME |
Character(1) |
VARCHAR2(1) NOT NULL |
Update Name
Y/N Table Edit
Default Value: N
|
| 9 |
SFA_UPDATE_ADDRESS |
Character(1) |
VARCHAR2(1) NOT NULL |
Update Addresses
1=Discard Incoming Address
2=Add if blank - Do not update
3=Always Update
Default Value: 2
|
| 10 |
UPDATE_PERSONAL |
Character(1) |
VARCHAR2(1) NOT NULL |
Update Bio/Demo Data
Y/N Table Edit
Default Value: N
|
| 11 |
ADDRESS_TYPE |
Character(4) |
VARCHAR2(4) NOT NULL |
Address Type
Prompt Table:
HCR_ADDR_TYP_I
|
| 12 |
EFC_SOURCE_IND |
Character(1) |
VARCHAR2(1) NOT NULL |
EFC Source
B=IM Base Calc
F=Estimated FM Calc
G=Larger of three
O=IM w/Options
Default Value: B
|
| 13 |
SM_PARM_CD |
Character(15) |
VARCHAR2(15) NOT NULL |
Search Match Parameter Code. This field stores the high level key for a Search Match Parameter definition.
Prompt Table:
SCC_SM_PARM_VW
Set Control Field: SM_PARM_CD
|
| 14 |
MAX_MATCH_LEVEL |
Number(3,0) |
SMALLINT NOT NULL |
Max Search Match Level
Prompt Table:
SCC_SM_BTCH_VW1
|
| 15 |
USE_EFC_OVERRIDE |
Character(1) |
VARCHAR2(1) NOT NULL |
Flag that triggers usage of EFC Override values in Need Analysis calculations.
Default Value: N
|
| 16 |
SFA_PF_INAS_CALREQ |
Character(1) |
VARCHAR2(1) NOT NULL |
Store INAS Calc Request
|
| 17 |
SFA_PF_UPDAT_PHONE |
Character(1) |
VARCHAR2(1) NOT NULL |
Update Phone
1=Discard Incoming Phone
2=Add if blank - Do not update
3=Always Update
Default Value: 1
|
| 18 |
PHONE_TYPE |
Character(4) |
VARCHAR2(4) NOT NULL |
Phone Type
BUSN=Business
CAMP=Campus
CELL=Mobile
DORM=Dormitory
FAX=FAX
HOME=Home
MAIN=Main
OTR=Other
PGR1=Pager 1
PGR2=Pager 2
TELX=Telex
WORK=Work
Prompt Table:
SCC_PERS_PHN_H
|
| 19 |
SFA_PF_SM_ACTION |
Character(1) |
VARCHAR2(1) NOT NULL |
Search/Match No Match Action
A=Allow Add if Eligible
S=Suspend
|