AV_PRIORWORK_VW

(SQL View)
Index Back

PriorWork Experience

View created to avoid the security attached to the priorwork entity. Used in query.

SELECT A.INSTITUTION , A.EMPLID , B.START_DT , B.END_DT , B.TITLE_LONG , B.EMPLOYMENT_DESCR , B.EXT_ORG_ID , B.CITY , B.PHONE , B.STATE , B.COUNTRY , B.COUNTRY_CODE , B.RETIRED FROM PS_AV_BIO_BUILD A , PS_SCC_PRIORWORK B WHERE A.EMPLID = B.EMPLID

# PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description
1 INSTITUTION Character(5) VARCHAR2(5) NOT NULL Academic Institution
2 EMPLID Character(11) VARCHAR2(11) NOT NULL Employee ID
3 START_DT Date(10) DATE Start Date
4 END_DT Date(10) DATE end date
5 TITLE_LONG Character(50) VARCHAR2(50) NOT NULL Title Long
6 EMPLOYMENT_DESCR Character(50) VARCHAR2(50) NOT NULL Employment Description
7 EXT_ORG_ID Character(11) VARCHAR2(11) NOT NULL External Org ID
8 CITY Character(30) VARCHAR2(30) NOT NULL City
9 PHONE Character(24) VARCHAR2(24) NOT NULL Telephone
10 STATE Character(6) VARCHAR2(6) NOT NULL State
11 COUNTRY Character(3) VARCHAR2(3) NOT NULL Country
12 COUNTRY_CODE Character(3) VARCHAR2(3) NOT NULL Country Code
13 RETIRED Character(1) VARCHAR2(1) NOT NULL Retired (Y/N)

Y/N Table Edit