LM_BO005_B1_VW

(SQL View)
 Index Back

For TU Expiration Report

For TU Expiration Report

SELECT D.OPRID , D.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 , B.NAME , A.LM_ITM_START_DT , A.LM_ITM_END_DT , A.LM_NO_OF_TUS , A.LM_AMT_PAID , A.CURRENCY_CD , A.LM_BALANCE_TUS , A.LM_OWNER_ID , R.LANGUAGE_CD FROM PS_LM_RUNCTL_FI D , PS_LM_TUPOOL_VW A , PS_LM_PER_NAME_VW B , PS_PRCSRUNCNTL R WHERE D.OPRID=R.OPRID AND D.RUN_CNTL_ID =R.RUN_CNTL_ID AND A.LM_OWNER_ID = B.LM_PERSON_ID AND ( A.LM_ORG_TYPE = D.LM_ORG_TYPE_RPT OR D.LM_ORG_TYPE_RPT = 'ALL') AND ( A.LM_ORGANIZATION_ID = D.LM_ORGANIZATION_ID OR D.LM_ORGANIZATION_ID = 0) AND ( A.LM_TU_POOL_ID = D.LM_TU_POOL_ID OR D.LM_TU_POOL_ID = 0) AND (( A.LM_ITM_START_DT >= D.LM_ITM_START_DT OR D.LM_ITM_START_DT IS NULL) AND A.LM_ITM_END_DT BETWEEN D.FROMDATE AND D.THRUDATE OR ( D.FROMDATE IS NULL AND D.THRUDATE IS NULL) OR ( A.LM_ITM_END_DT >= D.FROMDATE AND D.THRUDATE IS NULL) OR ( A.LM_ITM_END_DT <= D.THRUDATE AND D.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