| # |
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: OPR_DEF_TBL_CS.AID_YEAR
Prompt Table:
AID_YEAR_TBL
|
| 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
|
| 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: 1
|
| 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
|
| 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.
Y/N Table Edit
Default Value: N
|
| 16 |
SFA_PF_INAS_CALREQ |
Character(1) |
VARCHAR2(1) NOT NULL |
Store INAS Calc Request
Y/N Table Edit
|
| 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
Default Value: S
|
| 20 |
SFA_PF_FATM_ACTION |
Character(1) |
VARCHAR2(1) NOT NULL |
Require FA Term
N=No
Y=Yes
Default Value: N
|
| 21 |
SFA_PF_PROC_ACT |
Character(1) |
VARCHAR2(1) NOT NULL |
Aid Proc Status Pkg Completed
0=Suspend
1=Load/Reset Status to Applied
|
| 22 |
INAS_RFC_CALL |
Character(1) |
VARCHAR2(1) NOT NULL |
Calc EFC via Remote Call
N=No
Y=Yes
|
| 23 |
SFA_PF_ADD_PERSON |
Character(1) |
VARCHAR2(1) NOT NULL |
N=Suspend New Student
Y=Create New Student
|