LM_BO004_UN2_VW(SQL View) |
Index Back |
---|---|
For TU Usage reportFor TU Usage report |
SELECT A.OPRID , A.RUN_CNTL_ID , A.LM_ORGANIZATION_ID , A.LM_ORG_DESCR , A.LM_TU_POOL_ID , A.LM_TU_POOL_NAME , A.LM_TU_POOL_DESCR , A.NAME , A.LM_PRG_CD , A.LM_PRG_LONG_NM , A.LM_PRG_STTS , A.LM_ENRL_DT , %DateNull , %DateNull , A.LM_NO_OF_TUS , A.XLATLONGNAME FROM PS_LM_BO004_B2_VW A , PSOPTIONS B WHERE A.LANGUAGE_CD = B.LANGUAGE_CD |
# | 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_ORGANIZATION_ID | Number(15,0) | DECIMAL(15) NOT NULL | Organization ID |
4 | LM_ORG_DESCR | Character(50) | VARCHAR2(50) NOT NULL | Customer Description |
5 | LM_TU_POOL_ID | Number(10,0) | DECIMAL(10) NOT NULL | Training Unit Pool No. Unique key for Training Unit Pool Record. |
6 | LM_TU_POOL_NAME | Character(20) | VARCHAR2(20) NOT NULL | Training Unit Pool |
7 | LM_TU_POOL_DESCR | Character(40) | VARCHAR2(40) NOT NULL | Training Unit Pool Description. |
8 | NAME | Character(50) | VARCHAR2(50) NOT NULL | Name |
9 | LM_PRG_CD | Character(30) | VARCHAR2(30) NOT NULL | Program Code is a user defined field. This field allows duplicates and is not part of the primary key structure. |
10 | LM_PRG_LONG_NM | Character(200) | VARCHAR2(200) NOT NULL | Program Long Name |
11 | 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 |
12 | LM_ENRL_DT | Date(10) | DATE | Enrollment/Registration Date |
13 | LM_START_DT | Date(10) | DATE | Start Date |
14 | LM_END_DT | Date(10) | DATE | End Date |
15 | LM_NO_OF_TUS | Number(14,3) | DECIMAL(13,3) NOT NULL | No of Training Units available/used. |
16 | XLATLONGNAME | Character(30) | VARCHAR2(30) NOT NULL | Translate Long Name |