OPRIDEFFDTDefault Value: %date
LM_PRQRT_BASE_1(SQL View) |
Index Back |
|---|---|
For PrereqFor Prereq |
| SELECT B.OPRID , G.EFFDT , K.RUN_CNTL_ID , L.LM_CI_ID , L.EFFDT , L.LM_CS_LONG_NM , L.LM_CRSE_CODE , B.LM_START_DT , B.LM_END_DT , K.LM_FCLTY , K.NAME , A.LM_PERSON_ID , C.FIRST_NAME , C.LAST_NAME , D.FIELDNAME , D.FIELDVALUE , D.EFFDT , D.XLATLONGNAME , G.LM_CI_ID , G.LM_CS_LONG_NM , G.LM_CRSE_CODE , H.FIELDNAME , H.FIELDVALUE , H.EFFDT , H.XLATLONGNAME , I.FIELDNAME , I.FIELDVALUE , I.EFFDT , I.XLATLONGNAME , J.LM_START_DT , J.LM_END_DT ,M.LANGUAGE_CD FROM PS_LM_ENRMT_RPT_VW A , PS_LM_ACT_LE_VW B , PS_LM_PERS_NAME_VW C , PSXLATITEM D , PS_LM_CI_PRQ_VW E , PS_LM_ENRMT_RPT_VW F , PS_LM_CI_ALL_VW G , PSXLATITEM H , PSXLATITEM I , PS_LM_ACT_VW J , PS_RUN_ENRL_RPT K , PS_LM_CI_ALL_VW L , PS_PRCSRUNCNTL M WHERE B.OPRID = K.OPRID AND M.OPRID = K.OPRID AND M.RUN_CNTL_ID = K.RUN_CNTL_ID AND A.LM_STTS NOT IN ('CANC') AND B.LM_ACT_ID = A.LM_ACT_ID AND A.LM_PERSON_ID = C.LM_PERSON_ID AND D.EFFDT = ( SELECT MAX(D_ED.EFFDT) FROM PSXLATITEM D_ED WHERE D.FIELDNAME = D_ED.FIELDNAME AND D.FIELDVALUE = D_ED.FIELDVALUE AND D_ED.EFFDT <= %CurrentDateIn ) AND D.FIELDNAME = 'LM_STTS' AND D.FIELDVALUE = A.LM_STTS AND A.LM_CI_ID = E.LM_CI_ID AND E.LM_PRQ_OBJ_TYPE = '10' AND E.LM_OBJ_ID = F.LM_CI_ID AND F.LM_STTS NOT IN ('CANC') AND F.LM_PERSON_ID = A.LM_PERSON_ID AND G.LM_CI_ID = F.LM_CI_ID AND F.LM_ENRL_DT BETWEEN G.EFFDT AND G.LM_END_EFFDT AND H.EFFDT = ( SELECT MAX(H_ED.EFFDT) FROM PSXLATITEM H_ED WHERE H.FIELDNAME = H_ED.FIELDNAME AND H.FIELDVALUE = H_ED.FIELDVALUE AND H_ED.EFFDT <= %CurrentDateIn ) AND H.FIELDNAME = 'LM_PRQ_OBJ_TYPE' AND H.FIELDVALUE = E.LM_PRQ_OBJ_TYPE AND I.EFFDT = ( SELECT MAX(I_ED.EFFDT) FROM PSXLATITEM I_ED WHERE I.FIELDNAME = I_ED.FIELDNAME AND I.FIELDVALUE = I_ED.FIELDVALUE AND I_ED.EFFDT <= %CurrentDateIn ) AND I.FIELDNAME = 'LM_STTS' AND I.FIELDVALUE = F.LM_STTS AND J.LM_ACT_ID = F.LM_ACT_ID AND K.LM_ACT_ID = A.LM_ACT_ID AND L.LM_CI_ID = A.LM_CI_ID AND A.LM_ENRL_DT BETWEEN L.EFFDT AND L.LM_END_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 | EFFDT |
Date(10) | DATE |
Effective Date
Default Value: %date |
| 3 | RUN_CNTL_ID | Character(30) | VARCHAR2(30) NOT NULL | Run Control ID |
| 4 | LM_PRQ_RPT_CI_ID | Number(10,0) | DECIMAL(10) NOT NULL | Prereq Report CI ID |
| 5 | LM_PRQ_RT_CI_EFFDT | Date(10) | DATE | Pre req Report Effective Date |
| 6 | LM_PRQ_RPT_CS_NM | Character(254) | VARCHAR2(254) NOT NULL | For Pre req Report |
| 7 | LM_PRQ_RPT_CS_CODE | Character(30) | VARCHAR2(30) NOT NULL | Field for Prere Report |
| 8 | LM_PRQ_RPT_ST_DATE | Date(10) | DATE | For Pre req Report |
| 9 | LM_PRQ_RPT_END_DT | Date(10) | DATE | For Pre req Report |
| 10 | LM_FCLTY | Character(50) | VARCHAR2(50) NOT NULL | Facility Description |
| 11 | NAME | Character(50) | VARCHAR2(50) NOT NULL | Name |
| 12 | LM_PERSON_ID | Number(15,0) | DECIMAL(15) NOT NULL | ELM Person ID |
| 13 | FIRST_NAME | Character(30) | VARCHAR2(30) NOT NULL | First Name field |
| 14 | LAST_NAME | Character(30) | VARCHAR2(30) NOT NULL | Last Name Field |
| 15 | LM_PRQ_RPT_ENST_FN | Character(18) | VARCHAR2(18) NOT NULL | For Pre Req Report |
| 16 | LM_PRQ_RPT_ENST_FV | Character(4) | VARCHAR2(4) NOT NULL | For Prereq Report |
| 17 | LM_PRQRPT_ENST_EDT | Date(10) | DATE | For Prereq report |
| 18 | LM_PRQ_RPT_EN_STTS | Character(30) | VARCHAR2(30) NOT NULL | Field for Prere Report |
| 19 | LM_CI_ID | Number(10,0) | DECIMAL(10) NOT NULL | Catalog Item ID - System Generated ID Number associated with each Catalog Item |
| 20 | LM_PRG_LONG_NM | Character(200) | VARCHAR2(200) NOT NULL | Program Long Name |
| 21 | LM_CRSE_CODE | Character(30) | VARCHAR2(30) NOT NULL | Course Code - User defined Code |
| 22 | LM_PRQ_RPT_ENTY_FN | Character(18) | VARCHAR2(18) NOT NULL | For Pre Req Report |
| 23 | LM_PRQ_RPT_ENTY_FV | Character(4) | VARCHAR2(4) NOT NULL | For Prereq Report |
| 24 | LM_PRQRPT_ENTY_EDT | Date(10) | DATE | For Prereq report |
| 25 | LM_PRQ_RPT_EN_TYPE | Character(30) | VARCHAR2(30) NOT NULL | Field for Prere Report |
| 26 | LM_PRQ_RPT_PQST_FN | Character(18) | VARCHAR2(18) NOT NULL | For Pre Req Report |
| 27 | LM_PRQ_RPT_PQST_FV | Character(4) | VARCHAR2(4) NOT NULL | For Prereq Report |
| 28 | LM_PRQRPT_PQST_EDT | Date(10) | DATE | For Prereq report |
| 29 | LM_PRQ_RPT_PRQ_STS | Character(30) | VARCHAR2(30) NOT NULL | Field for Prere Report |
| 30 | LM_START_DT | Date(10) | DATE | Start Date |
| 31 | LM_END_DT | Date(10) | DATE | End Date |
| 32 | LANGUAGE_CD | Character(3) | VARCHAR2(3) NOT NULL | Language Code |