SAD_OWO_AVB_VW

(SQL View)
Index Back

AVB contract appendixes view

View on contract appendix table showing the AVB appendixes (appendix type 3)

SELECT SAD_CONTRACTNR_NLD , INSTITUTION , ACAD_PROG , SAD_APPDIX_TYP_NLD , SAD_APPDIX_ORD_NLD , SAD_APPENDIX_NLD , ACAD_PLAN , ITEM_AMT , HEGIS_CODE , DESCR , DESCRLONG FROM PS_SAD_OWO_APP_NLD WHERE SAD_APPDIX_TYP_NLD = '3'

  • Related Language Record: SADOWOAVBVWLNG
  • # PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description
    1 SAD_CONTRACTNR_NLD Number(12,0) DECIMAL(12) NOT NULL Unique OWO contract number.

    Default Value: SAD_STD_CON_NLD.SAD_CONTRACTNR_NLD

    2 INSTITUTION Character(5) VARCHAR2(5) NOT NULL Academic Institution
    3 ACAD_PROG Character(5) VARCHAR2(5) NOT NULL Academic Program
    4 SAD_APPDIX_TYP_NLD Character(2) VARCHAR2(2) NOT NULL Sort of appendix: 1 = plans, 2 = AOHS, 3 = AVB, 4=text
    1=Plans
    2=AOHS
    3=AVB
    4=Extra text

    Default Value: 3

    5 SAD_APPDIX_ORD_NLD Number(4,0) SMALLINT NOT NULL Incremental appendix order number for effective dated rows within an appendix
    6 SAD_APPENDIX_NLD Character(12) VARCHAR2(12) NOT NULL Appendix reference id (name of appendix)

    Prompt Table: SAD_AVB_NLD_VW

    7 ACAD_PLAN Character(10) VARCHAR2(10) NOT NULL Academic Plan
    8 ITEM_AMT Signed Number(18,2) DECIMAL(16,2) NOT NULL Item Amount
    9 HEGIS_CODE Character(8) VARCHAR2(8) NOT NULL HEGIS Code
    10 DESCR Character(30) VARCHAR2(30) NOT NULL Description
    11 DESCRLONG Long Character CLOB Long Description