SFA_COD_STUDENT

(SQL Table)
Index Back

COD Student Information

Contains general information about the student.

  • Parent record: SFA_COD_ATTSCHL
  • # PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description
    1 SFA_CR_DOCUMENT_ID Character(34) VARCHAR2(34) NOT NULL Document ID
    2 SFA_CR_RPT_SCHL_ID Character(8) VARCHAR2(8) NOT NULL Reporting School ID
    3 SFA_CR_ATT_SCHL_ID Character(8) VARCHAR2(8) NOT NULL Attended School ID
    4 EMPLID Character(11) VARCHAR2(11) NOT NULL Employee 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_DRV_LIC_ST Character(3) VARCHAR2(3) NOT NULL Drivers License State
    10 SFA_CR_DRV_LIC_NBR Character(20) VARCHAR2(20) NOT NULL Drivers License Number
    11 SFA_CR_BIRTH_DT Character(10) VARCHAR2(10) NOT NULL Birthdate
    12 SFA_CR_FIRST_NAME Character(35) VARCHAR2(35) NOT NULL First Name
    13 SFA_CR_MIDDLE_INIT Character(35) VARCHAR2(35) NOT NULL Middle Initial
    14 SFA_CR_LAST_NAME Character(35) VARCHAR2(35) NOT NULL Last Name
    15 SFA_CR_EMAIL_ADDR Character(128) VARCHAR2(128) NOT NULL Email Address
    16 SFA_CR_CITIZN_STAT Character(20) VARCHAR2(20) NOT NULL Citizenship Status
    17 SFA_CR_NOTE_MSG Character(20) VARCHAR2(20) NOT NULL Note Message
    18 SFA_CR_RESPONSE_CD Character(15) VARCHAR2(15) NOT NULL Response Code
    19 SFA_CR_PERSON_ID Character(20) VARCHAR2(20) NOT NULL School Assigned Person ID
    20 SFA_CR_USGLIMITAPL Character(5) VARCHAR2(5) NOT NULL Subsidized Usage Limit Applies
    21 SFA_CR_ACTSUMCUSG Character(5) VARCHAR2(5) NOT NULL Sum ACT NonCredTCertSubUSG PD
    22 SFA_CR_ACTSUMUSG Character(5) VARCHAR2(5) NOT NULL Sum Actual Sub Usage Periods
    23 SFA_CR_SUFFIX Character(10) VARCHAR2(10) NOT NULL Suffix