SSR_NZSCED_VW

(SQL View)
Index Back

Prompt table for NZSCED Detail


SELECT A.SSR_NZSCED_DTL , A.EFFDT , A.DESCR , A.SSR_NZSCED_BROADCD , A.SSR_NZSCED_NAR_CD , A.SSR_NZSCED_DTL_CD FROM PS_SSR_NZSCED_DET A

  • Related Language Record: SSR_NZSCED_VWLN
  • # PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description
    1 SSR_NZSCED_DTL Character(6) VARCHAR2(6) NOT NULL The full six digit NZSCED detailed field of study code
    2 EFFDT Date(10) DATE Effective Date
    3 DESCR Character(30) VARCHAR2(30) NOT NULL Description
    4 SSR_NZSCED_BROADCD Character(2) VARCHAR2(2) NOT NULL NZSCED Broad Code

    Prompt Table: SSR_NZSCED_BRD

    5 SSR_NZSCED_NAR_CD Character(2) VARCHAR2(2) NOT NULL NZSCED Narrow Code

    Prompt Table: SSR_NZSCED_NAR

    6 SSR_NZSCED_DTL_CD Character(2) VARCHAR2(2) NOT NULL NZSCED detailed field of study code