LM_BO004_UN2_VW

(SQL View)
Index Back

For TU Usage report

For 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