SFA_PF_NCFAM_ST

(SQL Table)
Index Back

Family Member StagingTable

Family Member StagingTable

  • Parent record: SFA_PF_CNTRL_ST
  • # 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

    Prompt Table: INST_CONTROL

    6 MEMBER_SEQ Number(2,0) SMALLINT NOT NULL Family Member Sequence
    7 RELATIONSHIP_CD Character(1) VARCHAR2(1) NOT NULL Relationship
    1=Student's Parent
    2=Student's Stepparent
    3=Student's Brother/Sister/Step
    4=Student's Spouse
    5=Student's Son/Daughter
    6=Student's Grandparent
    7=Student's Stepbrother/sister
    8=Other
    ?=Invalid Entry
    8 ATTEND_COLLEGE Character(1) VARCHAR2(1) NOT NULL College Status
    0=Not Applicable
    1=Full-Time
    2=Half-Time
    3=Not Attending
    9 COLLEGE_TYPE Character(1) VARCHAR2(1) NOT NULL College Type
    1=2-Year Public
    2=2-Year Private
    3=4-Year Public
    4=4-Year Private
    5=Graduate/Professional
    6=Proprietary
    7=Other
    10 SFA_PF_STUAGE_STG Character(2) VARCHAR2(2) NOT NULL Age
    11 SFA_PF_NAME Character(20) VARCHAR2(20) NOT NULL Name
    12 SFA_PF_LNAME Character(35) VARCHAR2(35) NOT NULL Last Name
    13 SFA_PF_FNAME Character(35) VARCHAR2(35) NOT NULL First Name
    14 SFA_PF_ATTCOLL_19 Character(1) VARCHAR2(1) NOT NULL Attend College Code
    F=Yes, Full Time
    H=Yes, Half Time
    15 SFA_PF_SCHOOL_NM Character(50) VARCHAR2(50) NOT NULL Name of School