SSR_RUN_TLT_VW

(SQL View)
Index Back

Test List View

Test List View

SELECT DISTINCT A.OPRID , A.RUN_CNTL_ID , B.SSR_TST_ID_NLD , C.SSR_TST_EXAMTP_NLD , C.EFFDT FROM PS_SSR_RUNTSLS_NLD A , PS_SSR_TLTLINE_NLD B , PS_SSR_TST_CAT_NLD C WHERE A.SSR_TLT_ID_NLD = B.SSR_TLT_ID_NLD AND B.EFFDT = ( SELECT MAX(B_ED.EFFDT) FROM PS_SSR_TLTLINE_NLD B_ED WHERE B.SSR_TLT_ID_NLD = B_ED.SSR_TLT_ID_NLD AND B_ED.EFFDT <= %CurrentDateIn) AND B.SSR_TST_ID_NLD = C.SSR_TST_ID_NLD AND C.EFFDT = ( SELECT MAX(C_ED.EFFDT) FROM PS_SSR_TST_CAT_NLD C_ED WHERE C.SSR_TST_ID_NLD = C_ED.SSR_TST_ID_NLD AND C_ED.EFFDT <= B.EFFDT)

# PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description
1 OPRID Character(30) VARCHAR2(30) NOT NULL A user's ID (see PSOPRDEFN).
2 RUN_CNTL_ID Character(30) VARCHAR2(30) NOT NULL Run Control ID
3 SSR_TST_ID_NLD Character(8) VARCHAR2(8) NOT NULL Test ID
4 SSR_TST_EXAMTP_NLD Character(1) VARCHAR2(1) NOT NULL Test examination type
B=Combination Grade
C=Central End Exam
E=End Exam
Q=Qualification
S=School Exam
U=Partial Qualification
5 EFFDT Date(10) DATE Effective Date

Default Value: %date