SFA_PF_CNTRL_ST

(SQL Table)
 Index Back

Inst Control Staging Data

Inst Control Staging Data

  • Parent record: STUDENT_AID

    • # PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description
    1 SFA_PF_QUEUE_INST Number(9,0) DECIMAL(9) NOT NULL Load Instance
    2 CSS_ID Character(7) VARCHAR2(7) NOT NULL CSS ID Number
    3 INSTITUTION Character(5) VARCHAR2(5) NOT NULL Academic Institution

    Prompt Table: INSTITUTION_TBL

    4 AID_YEAR Character(4) VARCHAR2(4) NOT NULL Aid Year

    Prompt Table: STUDENT_AID

    5 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
    6 SFA_APPL_TYPE Character(1) VARCHAR2(1) NOT NULL Application Type
    1=Domestic PROFILE
    2=Noncustodial PROFILE
    3=Registration Only Record
    4=International PROFILE
    7 CSS_SCHOOL_CODE Character(4) VARCHAR2(4) NOT NULL CSS School Code
    8 SPECIAL_PROCESSING Character(1) VARCHAR2(1) NOT NULL Special Circumstances
    1=Yes
    N=No
    Y=Yes
    9 SFA_PF_MTCH_LVL Number(3,0) SMALLINT NOT NULL Max Match Level Found
    10 SFA_PF_ADD_ACTION Character(1) VARCHAR2(1) NOT NULL F
    A=Add New Record Only
    R=Overwrite Existing Record
    11 ADMIT_LVL Character(1) VARCHAR2(1) NOT NULL Student's Admit Lvl
    0=0 - Student Not Found
    1=1 - Has Not Applied
    2=2 - Inactive
    3=3 - Applied/Pending
    4=4 - Admitted
    5=5 - Accepted/Continuing
    12 REPORTING_TYPE Character(1) VARCHAR2(1) NOT NULL Institutional Reporting Type
    1=1st Time Application
    2=Subsequent Application
    3=Registration Only
    13 ID_OVERRIDE Character(1) VARCHAR2(1) NOT NULL ID Override
    N=No
    Y=Yes

    Default Value: N

    14 SUSPEND_REASON Character(1) VARCHAR2(1) NOT NULL Suspend Reason
    1=1 - Student ID not Found
    2=2 - Student not at Load Level
    3=3 - Final Review Flag Set
    4=4 - No SAI Calculation
    5=5 - Invalid School Code
    6=6 - Student Id already Exists
    7=ISIR Tran Nbr out of Sequence
    8=8 - Registration Only Record
    9=9 -Non-Unique Student ID Found
    A=A - Student not at Admit Level
    E=SAI Mismatch
    F=10 - FA Term Not Built
    H=13 - HHB Add Person Suspend
    L=Load Update Profile Set To No
    M=11 - Manually Set to Suspended
    P=12- Packaging Completed
    T=Prof Tran Nbr out of Sequence
    15 SFA_PF_SKIP_REASON Character(1) VARCHAR2(1) NOT NULL Skip Reason
    1=Student Already Exists
    2=Final Review Flag Set
    3=Student Not at Suspend Level
    4=Manually Set to Skipped
    16 SFA_PF_DTAPLOD_STG Character(10) VARCHAR2(10) NOT NULL Date Application Loaded
    17 SFA_PF_DTAPRCD_STG Character(10) VARCHAR2(10) NOT NULL Date Application Received
    18 SFA_PF_CRET_DT_STG Character(10) VARCHAR2(10) NOT NULL Created Date
    19 SFA_PF_NCPDTRC_STG Character(10) VARCHAR2(10) NOT NULL NCP Application Receipt Date
    20 SFA_PF_LOAD_STATUS Character(1) VARCHAR2(1) NOT NULL Load Status
    D=Discarded
    E=Error Encountered
    K=Skipped
    L=Loaded
    P=Processed
    Q=User Delete
    S=Suspended
    U=Unprocessed
    21 SFA_PF_PROC_ACTN Character(1) VARCHAR2(1) NOT NULL Processing Action
    A=Add Profile
    R=Recycle

    Default Value: R

    22 SFA_PF_REG_RCP_DT Character(10) VARCHAR2(10) NOT NULL Registration Receipt Date
    23 SFA_PF_REC_TYPE Character(1) VARCHAR2(1) NOT NULL Student Record Type
    1=Original Data
    3=ACR
    4=Duplicate Record
    24 SFA_PF_DISCARD_RSN Character(1) VARCHAR2(1) NOT NULL Skip Reason
    1=Registration Only Record
    2=Non- Custodial PROFILE record
    25 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.
    26 SFA_PF_EXPLN_TXT Long Character CLOB Explanations Text
    27 SFA_PF_ALT_INST Character(5) VARCHAR2(5) NOT NULL Alternate Institution

    Prompt Table: INSTITUTION_TBL
    Set Control Field: INSTITUTION

    28 SFA_PF_ADDCOL_SBDT Character(10) VARCHAR2(10) NOT NULL Add College Submit Date
    29 SFA_PF_HHOLD_TYPE Character(1) VARCHAR2(1) NOT NULL HouseHold Type
    A=HHA
    B=HHB
    C=HHA / HHB
    30 SFA_PF_HHB_IND Character(1) VARCHAR2(1) NOT NULL HHB Indicated
    N=No
    Y=Yes
    31 SFA_PF_CBFINAID_ID Character(7) VARCHAR2(7) NOT NULL CB FinAid ID
    32 SFA_PF_STU_REC_19 Character(1) VARCHAR2(1) NOT NULL Student Record Type
    1=Initial
    2=School Added
    33 SFA_PF_APP_TYPE_19 Character(1) VARCHAR2(1) NOT NULL Application Type
    1=Domestic
    2=Canadian
    3=International
    34 SFA_PF_CHNG_EMPLMT Character(1) VARCHAR2(1) NOT NULL Change in Employment
    N=No
    Y=Yes
    35 SFA_PF_SCHOLARSHIP Character(1) VARCHAR2(1) NOT NULL Scholarship
    N=No
    Y=Yes
    36 SFA_PF_DEN_EXP_IND Character(1) VARCHAR2(1) NOT NULL Medical/Dental Exp
    N=No
    Y=Yes
    37 SFA_PF_PVT_SCH_IND Character(1) VARCHAR2(1) NOT NULL Siblings Private School Ind
    N=No
    Y=Yes
    38 SFA_PF_CATASTR_IND Character(1) VARCHAR2(1) NOT NULL Catastrophic Event
    N=No
    Y=Yes
    39 SFA_PF_ELDER_CARE Character(1) VARCHAR2(1) NOT NULL Elder Care
    N=No
    Y=Yes
    40 SFA_PF_NONRECUR_IN Character(1) VARCHAR2(1) NOT NULL Non Recurring Income
    N=No
    Y=Yes
    41 SFA_PF_FIN_SUP_IND Character(1) VARCHAR2(1) NOT NULL Financial Support
    N=No
    Y=Yes
    42 SFA_PF_NONE_IND Character(1) VARCHAR2(1) NOT NULL None
    N=No
    Y=Yes
    43 SFA_PF_OTH_IND Character(1) VARCHAR2(1) NOT NULL Other
    N=No
    Y=Yes
    44 SFA_PF_COVID19_IND Character(1) VARCHAR2(1) NOT NULL Covid-19
    N=No
    Y=Yes
    45 SFA_PF_TXN_STG Character(1) VARCHAR2(1) NOT NULL This field is used to hold the Transaction umber of the Profile files
    46 SFA_PF_CORECTN_IND Character(1) VARCHAR2(1) NOT NULL This field is used to hold the Correction Record Indictor of the Profile files
    N=No
    Y=Yes
    47 SFA_PF_CRTN_DT_STG Character(10) VARCHAR2(10) NOT NULL Correction Date
    48 SFA_PF_LI_PATHELIG Character(1) VARCHAR2(1) NOT NULL Low Income Eligible
    N=No
    Y=Yes
    49 SFA_PF_PROF_LITE Character(1) VARCHAR2(1) NOT NULL Profile Lite
    N=No
    Y=Yes