LM_REG_AUD_VW(SQL View) |
Index Back |
|---|---|
Registration Audit ViewRegistration Audit View |
| SELECT A.LM_PRG_REG_ID , A.LM_REG_STTS_SEQ , A.LM_PRG_STTS , A.LM_STTS_CHNG_DT , B.LM_PERSON_ID , B.LM_NAME_DISPLAY FROM PS_LM_PRG_REG_STTS A , PS_LM_PERS_NAME_VW B , PS_LM_OPRID_ID_VW C WHERE A.LM_ROW_ADDED_OPRID = C.OPRID AND C.LM_PERSON_ID = B.LM_PERSON_ID |
| # | PeopleSoft Field Name | PeopleSoft Field Type | Database Column Type | Description |
|---|---|---|---|---|
| 1 |  LM_PRG_REG_ID |
Number(10,0) | DECIMAL(10) NOT NULL | The Program Registration ID is a unique identifier for a learner's program enrollment. |
| 2 | LM_REG_STTS_SEQ |
Number(4,0) | SMALLINT NOT NULL | Status Sequence Number |
| 3 | LM_PRG_STTS | Character(4) | VARCHAR2(4) NOT NULL |
Program Reg Status
CANC=Dropped COMP=Completed DECL=Decline ENRL=Registered EXPR=Expired INCO=Not Completed INPO=In-Progress PEAP=Pending Approval PEPA=Pending Payment PLAN=Planned PPYA=Payment Approval REIS=Reissue REVK=Revoked WAIV=Waived WARN=Warning |
| 4 | LM_STTS_CHNG_DT | Date(10) | DATE | Status Change Date |
| 5 | LM_PERSON_ID | Number(15,0) | DECIMAL(15) NOT NULL | ELM Person ID |
| 6 | LM_NAME_DISPLAY | Character(50) | VARCHAR2(50) NOT NULL | Name Display field |