SAD_NCEA_ST_NZL

(SQL Table)
 Index Back

Record for NCEA test results

Holds additional fields relevant to NCEA test results. Sibling of STDNT_TEST

  • Parent record: STDNT_TEST

    • # PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description
    1 EMPLID Character(11) VARCHAR2(11) NOT NULL Employee ID
    2 TEST_ID Character(11) VARCHAR2(11) NOT NULL Test ID

    Prompt Table: SA_TEST_TBL

    3 SAD_NCEA_L3CR_APYR Number(3,0) SMALLINT NOT NULL New Zealand NCEA processing
    4 SAD_NCEA_LEV_3_ACH Character(1) VARCHAR2(1) NOT NULL New Zealand NCEA processing

    Y/N Table Edit

    5 SAD_NCEA_S_Q_AWARD Character(1) VARCHAR2(1) NOT NULL New Zealand NCEA processing

    Y/N Table Edit

    6 SAD_NCEA_TTCL3NACH Number(3,0) SMALLINT NOT NULL New Zealand NCEA processing
    7 SAD_NCEA_TTCRL3ACH Number(3,0) SMALLINT NOT NULL New Zealand NCEA processing
    8 SAD_NCEA_TTS_S_ACH Number(1,0) SMALLINT NOT NULL New Zealand NCEA processing
    9 SAD_NCEA_TTSSN_ACH Number(1,0) SMALLINT NOT NULL New Zealand NCEA processing
    10 SAD_NCEA_UEACHIEVE Character(1) VARCHAR2(1) NOT NULL New Zealand NCEA processing

    Y/N Table Edit

    11 SAD_NCEA_UELIT_ACH Character(1) VARCHAR2(1) NOT NULL New Zealand NCEA processing

    Y/N Table Edit

    12 SAD_NCEA_UENUM_ACH Character(1) VARCHAR2(1) NOT NULL New Zealand NCEA processing

    Y/N Table Edit