LM_BO005_B2_VW

(SQL View)
 Index Back

For TU Expiration Report

For TU Expiration Report

SELECT E.OPRID , E.RUN_CNTL_ID , C.LM_ORGANIZATION_ID , C.LM_ORG_DESCR , C.LM_TU_POOL_ID , C.LM_TU_POOL_NAME , C.LM_TU_POOL_DESCR , ' ' , C.LM_ITM_START_DT , C.LM_ITM_END_DT , C.LM_NO_OF_TUS , C.LM_AMT_PAID , C.CURRENCY_CD , C.LM_BALANCE_TUS , C.LM_OWNER_ID , R.LANGUAGE_CD FROM PS_LM_TUPOOL_VW C , PS_LM_RUNCTL_FI E , PS_PRCSRUNCNTL R WHERE E.OPRID=R.OPRID AND E.RUN_CNTL_ID =R.RUN_CNTL_ID AND C.LM_OWNER_ID = 0 AND ( C.LM_ORG_TYPE = E.LM_ORG_TYPE_RPT OR E.LM_ORG_TYPE_RPT = 'ALL') AND ( C.LM_ORGANIZATION_ID = E.LM_ORGANIZATION_ID OR E.LM_ORGANIZATION_ID = 0) AND ( C.LM_TU_POOL_ID = E.LM_TU_POOL_ID OR E.LM_TU_POOL_ID = 0) AND (( C.LM_ITM_START_DT >= E.LM_ITM_START_DT OR E.LM_ITM_START_DT IS NULL) AND C.LM_ITM_END_DT BETWEEN E.FROMDATE AND E.THRUDATE OR ( E.FROMDATE IS NULL AND E.THRUDATE IS NULL) OR ( C.LM_ITM_END_DT >= E.FROMDATE AND E.THRUDATE IS NULL ) AND ( C.LM_ITM_END_DT <= E.THRUDATE OR E.FROMDATE IS NULL))

# 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_ITM_START_DT Date(10) DATE TU Pool Item Start Date.
10 LM_ITM_END_DT Date(10) DATE TU Pool Item End Date
11 LM_NO_OF_TUS Number(14,3) DECIMAL(13,3) NOT NULL No of Training Units available/used.
12 LM_AMT_PAID Number(23,3) DECIMAL(22,3) NOT NULL Amount Paid so far towards the Enrollment Fee
13 CURRENCY_CD Character(3) VARCHAR2(3) NOT NULL Currency Code
14 LM_BALANCE_TUS Number(14,3) DECIMAL(13,3) NOT NULL No of Training Units available.
15 LM_OWNER_ID Number(15,0) DECIMAL(15) NOT NULL Owner ID
16 LANGUAGE_CD Character(3) VARCHAR2(3) NOT NULL Language Code