SADOWOAOHSVWLNG

(SQL View)
Index Back

Reld Ln on contract appendixes

SADOWOAOHSVWLNG is the language record related to SAD_OWO_AOHS_VW. A related language record enables text fields on a table to be translated into various languages for use in other countries.

SELECT SAD_CONTRACTNR_NLD , INSTITUTION , ACAD_PROG , SAD_APPDIX_TYP_NLD , SAD_APPDIX_ORD_NLD , SAD_APPENDIX_NLD , ACAD_PLAN , LANGUAGE_CD , DESCR , DESCRLONG FROM PS_SADOWOAPPNLDLNG WHERE SAD_APPDIX_TYP_NLD = '2'

  • Related Language Record for SAD_OWO_AOHS_VW
  • # 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)
    7 ACAD_PLAN Character(10) VARCHAR2(10) NOT NULL Academic Plan
    8 LANGUAGE_CD Character(3) VARCHAR2(3) NOT NULL Language Code
    9 DESCR Character(30) VARCHAR2(30) NOT NULL Description
    10 DESCRLONG Long Character CLOB Long Description