SAD_UC_IVGXJ_VW

(SQL View)
 Index Back

Experience View

Experience View

SELECT X.INSTITUTION , X.SAD_UC_APPCODE , X.SAD_UC_PERS_ID , X.SAD_UC_EXPER_ID , X.SAD_UC_ROLE_TITLE , X.SAD_UC_ORG_NAME , X.SAD_UC_WORK_CHILD , X.SAD_UC_COMMITMENT , X.SAD_UC_WORK_EXP , X.SAD_UC_DATE_FROM , X.SAD_UC_DATE_TO , X.SAD_UC_REL_SKILLS , X.SAD_UC_EST_START , X.SAD_UC_EST_END FROM PS_SAD_UC_IVGEXP X WHERE X.SAD_UC_SYSTEM = 'APPL' AND X.SAD_UC_WORK_CATG = 'J' AND X.SAD_UC_TIMESTAMP = ( SELECT MAX(X1.SAD_UC_TIMESTAMP) FROM PS_SAD_UC_IVGEXP X1 WHERE X1.INSTITUTION = X.INSTITUTION AND X1.SAD_UC_APPCODE = X.SAD_UC_APPCODE AND X1.SAD_UC_PERS_ID = X.SAD_UC_PERS_ID AND X1.SAD_UC_EXPER_ID = X.SAD_UC_EXPER_ID AND X1.SAD_UC_SYSTEM = X.SAD_UC_SYSTEM)

# PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description
1 INSTITUTION Character(5) VARCHAR2(5) NOT NULL Academic Institution

Prompt Table: INSTITUTION_TBL

2 SAD_UC_APPCODE Character(10) VARCHAR2(10) NOT NULL Application Code
3 SAD_UC_PERS_ID Character(10) VARCHAR2(10) NOT NULL Personalid - Unique personal identifier
4 SAD_UC_EXPER_ID Number(10,0) DECIMAL(10) NOT NULL Experience ID
5 SAD_UC_ROLE_TITLE Character(254) VARCHAR2(254) NOT NULL Job/Role Title
6 SAD_UC_ORG_NAME Character(254) VARCHAR2(254) NOT NULL Organisation Name
7 SAD_UC_WORK_CHILD Character(1) VARCHAR2(1) NOT NULL Field for DFE API
8 SAD_UC_COMMITMENT Character(10) VARCHAR2(10) NOT NULL Field for DFE API
9 SAD_UC_WORK_EXP Long Character(10240) CLOB Description of Work Experience
10 SAD_UC_DATE_FROM Date(10) DATE Date From
11 SAD_UC_DATE_TO Date(10) DATE Date To
12 SAD_UC_REL_SKILLS Character(1) VARCHAR2(1) NOT NULL Skills Relevant to Teaching

Y/N Table Edit

13 SAD_UC_EST_START Character(1) VARCHAR2(1) NOT NULL Estimated Start

Y/N Table Edit

14 SAD_UC_EST_END Character(1) VARCHAR2(1) NOT NULL Estimated End

Y/N Table Edit