SAD_OWO_AOHS_VW

(SQL View)
 Index Back

View on contract appendixes

View on contract appendixes showing all AOHS appendixes (type 2) connected to the OWO contract.

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 = '2'

  • Related Language Record: SADOWOAOHSVWLNG

    • # 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.
    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: 2

    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_AOHS_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