SCC_VOC_PRO_BND

(SQL View)
 Index Back

Vocado Academic Program Bind

Vocado Academic Program Bind Record

SELECT prog1.EMPLID ,prog1.institution ,prog1.acad_prog ,prog1.scc_row_add_oprid ,prog1.scc_row_add_dttm ,prog1.scc_row_upd_oprid ,prog1.scc_row_upd_dttm FROM PS_ACAD_PROG PROG1 WHERE NOT EXISTS ( SELECT 'X' FROM PS_SCC_SFA_MSG_MAP MAP1 WHERE PROG1.EMPLID = MAP1.EMPLID) AND prog1.scc_row_add_dttm = ( SELECT MAX(prog2.scc_row_add_dttm) FROM PS_ACAD_PROG prog2 WHERE prog1.emplid = prog2.emplid AND prog1.institution = prog2.institution AND prog1.acad_prog = prog2.acad_prog) AND prog1.effseq = ( SELECT MAX(prog2.effseq) FROM PS_ACAD_PROG prog2 WHERE prog1.emplid = prog2.emplid AND prog1.institution = prog2.institution AND prog1.acad_prog = prog2.acad_prog)

# PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description
1 EMPLID Character(11) VARCHAR2(11) NOT NULL Employee ID
2 INSTITUTION Character(5) VARCHAR2(5) NOT NULL Academic Institution
3 ACAD_PROG Character(5) VARCHAR2(5) NOT NULL Academic Program
4 SCC_ROW_ADD_OPRID Character(30) VARCHAR2(30) NOT NULL Created By
5 SCC_ROW_ADD_DTTM DateTime(26) TIMESTAMP Created
6 SCC_ROW_UPD_OPRID Character(30) VARCHAR2(30) NOT NULL Updated By
7 SCC_ROW_UPD_DTTM DateTime(26) TIMESTAMP Last Update Date/Time