OPRIDLM_PRQ_RPT_LNG3(SQL View) |
Index Back |
|---|---|
For PrereqFor 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 , F.XLATLONGNAME , A.LM_START_DT , A.LM_END_DT FROM PS_LM_PRQRT_BASE_3 A , PS_LM_CI_LANG B , PS_LM_PRG_LANG C , PSXLATITEMLANG D , PSXLATITEMLANG E , PSXLATITEMLANG F 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 AND A.LANGUAGE_CD = F.LANGUAGE_CD AND F.FIELDNAME = A.LM_PRQ_RPT_PQST_FN AND F.FIELDVALUE = A.LM_PRQ_RPT_PQST_FV AND F.EFFDT = A.LM_PRQRPT_PQST_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 |