JPM_SCH_LPMT_VW

(SQL View)
 Index Back

Schools/Universities

Use SCHOOL_TBL to assign codes to schools, colleges, and universities to use as an edit table for SCHOOL_CODE in your database. This view is used in non base language processing of the dynamic school code prompt in JPM

SELECT A.SCHOOL_CODE , B.LANGUAGE_CD , A.COUNTRY , A.STATE , B.DESCR FROM PS_SCHOOL_TBL A , PS_SCHOOL_TBL_LANG B WHERE A.COUNTRY = B.COUNTRY AND A. SCHOOL_CODE = B.SCHOOL_CODE UNION SELECT SCHOOL_CODE , ' ' , COUNTRY , STATE , DESCR FROM PS_SCHOOL_TBL C

# PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description
1 SCHOOL_CODE Character(10) VARCHAR2(10) NOT NULL School Code
2 LANGUAGE_CD Character(3) VARCHAR2(3) NOT NULL Language Code
3 COUNTRY Character(3) VARCHAR2(3) NOT NULL Country

Prompt Table: COUNTRY_TBL

4 STATE Character(6) VARCHAR2(6) NOT NULL State

Prompt Table: STATE_TBL

5 DESCR Character(30) VARCHAR2(30) NOT NULL Description