SSR_BR_RSLT_DEL

(SQL Table)
Index Back

BRON HO Msg Stage Table

BRON HO Delivery of Achieved Degree Msg Stage Table

  • Parent record: SSR_BR_TRIN_NLD
  • # PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description
    1 SAD_SL_TRANS_INOUT Character(1) VARCHAR2(1) NOT NULL Transaction Direction
    I=Inbound
    O=Outbound
    2 SAD_SL_TRANS_DTTM DateTime(26) TIMESTAMP Transaction DateTime
    3 SAD_SL_TRANS_SEQ Number(3,0) SMALLINT NOT NULL Sequence Number
    4 SSR_BR_INDEXID_NLD Character(50) VARCHAR2(50) NOT NULL Index ID
    5 SAD_SL_STUD_NBR Character(12) VARCHAR2(12) NOT NULL Student Number
    6 SAD_SL_SOFI_NBR Character(9) VARCHAR2(9) NOT NULL Social Fiscal Number
    7 SAD_SL_O_NBR Character(9) VARCHAR2(9) NOT NULL Onumber
    8 SCC_BRINCD_NLD Character(4) VARCHAR2(4) NOT NULL BRINcode
    9 SCC_SUBBRINCD_NLD Character(2) VARCHAR2(2) NOT NULL Sub Institute
    10 SSR_BRHO_RESEQ_NLD Character(20) VARCHAR2(20) NOT NULL BRON Result Seq Nbr
    11 SAD_SL_PROG_CODE Character(5) VARCHAR2(5) NOT NULL Program Code
    12 SSR_BR_AC_LDAP_NLD Character(2) VARCHAR2(2) NOT NULL Approved Academic Load
    DT=Part-Time
    DU=Dual
    VT=Full-Time
    13 SSR_ACAD_LEVEL_NLD Character(4) VARCHAR2(4) NOT NULL Academ. Level Higher Education
    A=Associate Degree
    B=Bachelor
    D=Propaedeutic Bachelor
    H=Main
    I=Initial Phase
    K=Candidate
    L=University teacher education
    M=Master
    P=Propaedeutic Phase
    Q=Post-Initial
    T=Interim Doctoral Exam
    V=Continuation Phase
    W=Continuing study
    14 SAD_BR_DIPL_DT_NLD Date(10) DATE Diploma Completed Date
    15 SSR_BR_FSTDEGR_NLD Character(1) VARCHAR2(1) NOT NULL First degree