SFA_CRC_STUDENT

(SQL Table)
Index Back

Student Information

Contains general information about the student.

  • Parent record: SFA_CRC_ATTSCHL
  • # PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description
    1 SFA_CR_DOCUMENT_ID Character(34) VARCHAR2(34) NOT NULL Document ID

    Prompt Table: SFA_CRC_DOCUMNT

    2 SFA_CR_RECIP_ID Character(12) VARCHAR2(12) NOT NULL CRC Recipient ID
    3 SFA_CR_ATT_SCHL_ID Character(8) VARCHAR2(8) NOT NULL Attended School ID
    4 SFA_CR_STUDENT_ID Character(20) VARCHAR2(20) NOT NULL School Assigned Student Id
    5 SFA_CR_ID_SSN Character(9) VARCHAR2(9) NOT NULL SSN Identifier
    6 SFA_CR_ID_BIRTH_DT Character(10) VARCHAR2(10) NOT NULL Birthdate Identifier
    7 SFA_CR_ID_LAST_NAM Character(35) VARCHAR2(35) NOT NULL Last Name Identifier
    8 SFA_CR_SSN Character(9) VARCHAR2(9) NOT NULL SSN
    9 SFA_CR_PERSON_ID Character(20) VARCHAR2(20) NOT NULL School Assigned Person ID
    10 SFA_CR_DRV_LIC_ST Character(3) VARCHAR2(3) NOT NULL Drivers License State
    11 SFA_CR_DRV_LIC_NBR Character(20) VARCHAR2(20) NOT NULL Drivers License Number
    12 SFA_CR_BIRTH_DT Character(10) VARCHAR2(10) NOT NULL Birthdate
    13 SFA_CR_FIRST_NAME Character(35) VARCHAR2(35) NOT NULL First Name
    14 SFA_CR_MIDDLE_INIT Character(35) VARCHAR2(35) NOT NULL Middle Initial
    15 SFA_CR_LAST_NAME Character(35) VARCHAR2(35) NOT NULL Last Name
    16 SFA_CR_EMAIL_ADDR Character(128) VARCHAR2(128) NOT NULL Email Address
    17 SFA_CR_EMAIL_UP_DT Character(10) VARCHAR2(10) NOT NULL Email Address Update Date
    18 SFA_CR_CITIZN_STAT Character(20) VARCHAR2(20) NOT NULL Citizenship Status
    19 SFA_CR_ALN_REG_NBR Character(10) VARCHAR2(10) NOT NULL Alien Registration Number
    20 SFA_CR_RESIDENT_CD Character(3) VARCHAR2(3) NOT NULL Residency State Province Code
    21 SFA_CR_RESIDENT_DT Character(10) VARCHAR2(10) NOT NULL Residency Established Date
    22 SFA_CR_RESPONSE_CD Character(15) VARCHAR2(15) NOT NULL Response Code