LM_PRQ_RPT_UN_1

(SQL View)
 Index Back

For Prereq

For Prereq

SELECT A.OPRID , A.RUN_CNTL_ID , A.LM_PRQ_RPT_CS_NM , A.LM_PRQ_RPT_CS_CODE , A.LM_PRQ_RPT_ST_DATE , A.LM_PRQ_RPT_END_DT , A.LM_FCLTY , A.NAME , A.LM_PERSON_ID , A.FIRST_NAME , A.LAST_NAME , A.LM_PRQ_RPT_EN_STTS , A.LM_PRG_LONG_NM , A.LM_CRSE_CODE , A.LM_PRQ_RPT_EN_TYPE , A.LM_PRQ_RPT_PRQ_STS , A.LM_START_DT , A.LM_END_DT FROM PS_LM_PRQRT_BASE_1 A , PSOPTIONS B WHERE (A.LANGUAGE_CD = B.LANGUAGE_CD) OR (NOT EXISTS( SELECT DISTINCT C.OPRID FROM PS_LM_PRQ_RPT_LNG1 C WHERE A.OPRID = C.OPRID AND A.RUN_CNTL_ID = C.RUN_CNTL_ID AND A.LM_CI_ID = C.LM_CI_ID AND A.LM_PERSON_ID = C.LM_PERSON_ID AND A.LM_PRQ_RPT_CI_ID = C.LM_PRQ_RPT_CI_ID ))

# 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 LM_PRQ_RPT_CS_NM Character(254) VARCHAR2(254) NOT NULL For Pre req Report
4 LM_PRQ_RPT_CS_CODE Character(30) VARCHAR2(30) NOT NULL Field for Prere Report
5 LM_PRQ_RPT_ST_DATE Date(10) DATE For Pre req Report
6 LM_PRQ_RPT_END_DT Date(10) DATE For Pre req Report
7 LM_FCLTY Character(50) VARCHAR2(50) NOT NULL Facility Description
8 NAME Character(50) VARCHAR2(50) NOT NULL Name
9 LM_PERSON_ID Number(15,0) DECIMAL(15) NOT NULL ELM Person ID
10 FIRST_NAME Character(30) VARCHAR2(30) NOT NULL First Name field
11 LAST_NAME Character(30) VARCHAR2(30) NOT NULL Last Name Field
12 LM_PRQ_RPT_EN_STTS Character(30) VARCHAR2(30) NOT NULL Field for Prere Report
13 LM_PRG_LONG_NM Character(200) VARCHAR2(200) NOT NULL Program Long Name
14 LM_CRSE_CODE Character(30) VARCHAR2(30) NOT NULL Course Code - User defined Code
15 LM_PRQ_RPT_EN_TYPE Character(30) VARCHAR2(30) NOT NULL Field for Prere Report
16 LM_PRQ_RPT_PRQ_STS Character(30) VARCHAR2(30) NOT NULL Field for Prere Report
17 LM_START_DT Date(10) DATE Start Date
18 LM_END_DT Date(10) DATE End Date