LM_PRQ_RPT_LNG4

(SQL View)
 Index Back

For Prereq

For Prereq

SELECT A.OPRID , A.RUN_CNTL_ID , B.LM_CI_ID , B.LM_CS_LONG_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 , D.XLATLONGNAME , C.LM_PRG_ID , C.LM_PRG_LONG_NM , A.LM_CRSE_CODE , E.XLATLONGNAME , A.LM_PRQ_RPT_PRQ_STS , A.LM_START_DT , A.LM_END_DT FROM PS_LM_PRQRT_BASE_4 A , PS_LM_CI_LANG B , PS_LM_PRG_LANG C , PSXLATITEMLANG D , PSXLATITEMLANG E WHERE A.LANGUAGE_CD = B.LANGUAGE_CD AND A.LM_PRQ_RT_CI_EFFDT = B.EFFDT AND A.LM_PRQ_RPT_CI_ID = B.LM_CI_ID AND A.EFFDT= C.EFFDT AND A.LM_CI_ID = C.LM_PRG_ID AND A.LANGUAGE_CD = C.LANGUAGE_CD AND A.LANGUAGE_CD = D.LANGUAGE_CD AND D.FIELDNAME = A.LM_PRQ_RPT_ENST_FN AND D.FIELDVALUE = A.LM_PRQ_RPT_ENST_FV AND D.EFFDT = A.LM_PRQRPT_ENST_EDT AND A.LANGUAGE_CD = E.LANGUAGE_CD AND E.FIELDNAME = A.LM_PRQ_RPT_ENTY_FN AND E.FIELDVALUE = A.LM_PRQ_RPT_ENTY_FV AND E.EFFDT = A.LM_PRQRPT_ENTY_EDT

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