LM_TU_POOL_IDLM_ORGANIZATION_IDLM_TUPOOL_VW(SQL View) |
Index Back |
|---|---|
TU PoolTU Pool view |
| SELECT DISTINCT A.LM_TU_POOL_ID , C.LM_ORGANIZATION_ID , C.LM_ORG_DESCR , A.LM_TU_POOL_NAME , A.LM_TU_POOL_DESCR , A.CURRENCY_CD , A.LM_CHARTFLD_TYPE , A.LM_CHARTFLD_VAL , A.LM_OWNER_ID , D.LM_BALANCE_TUS , D.LM_ITM_START_DT , D.LM_ITM_END_DT , D.LM_NO_OF_TUS , D.LM_AMT_PAID , C.LM_ORG_TYPE FROM PS_LM_TU_POOL_VW A , PS_LM_MOP_OWNR_VW B , PS_LM_ORGANIZATION C , PS_LM_TUPL_ITM_VW D WHERE A.LM_TU_POOL_ID = B.LM_MOP_ID AND B.LM_MOP_OWNER_ID = C.LM_ORGANIZATION_ID AND B.LM_MOP_TYPE='TUP' AND B.LM_MOP_OWNER_TYPE = 'ORG' AND A.LM_TU_POOL_ID = D.LM_TU_POOL_ID AND %CurrentDateIn BETWEEN C.EFFDT AND C.LM_END_EFFDT AND C.EFF_STATUS = 'A' |
| # | PeopleSoft Field Name | PeopleSoft Field Type | Database Column Type | Description |
|---|---|---|---|---|
| 1 | LM_TU_POOL_ID |
Number(10,0) | DECIMAL(10) NOT NULL | Training Unit Pool No. Unique key for Training Unit Pool Record. |
| 2 | LM_ORGANIZATION_ID |
Number(15,0) | DECIMAL(15) NOT NULL | Organization ID |
| 3 | LM_ORG_DESCR | Character(50) | VARCHAR2(50) NOT NULL | Customer Description |
| 4 | LM_TU_POOL_NAME | Character(20) | VARCHAR2(20) NOT NULL | Training Unit Pool |
| 5 | LM_TU_POOL_DESCR | Character(40) | VARCHAR2(40) NOT NULL | Training Unit Pool Description. |
| 6 | CURRENCY_CD | Character(3) | VARCHAR2(3) NOT NULL | Currency Code |
| 7 | LM_CHARTFLD_TYPE | Character(18) | VARCHAR2(18) NOT NULL | ChartField Type...One of 16 ChartFields. |
| 8 | LM_CHARTFLD_VAL | Character(20) | VARCHAR2(20) NOT NULL | ChartField Value...Depending on ChartField Type, it would store one of the 16 Chartfield values supported. |
| 9 | LM_OWNER_ID | Number(15,0) | DECIMAL(15) NOT NULL | Owner ID |
| 10 | LM_BALANCE_TUS | Number(14,3) | DECIMAL(13,3) NOT NULL | No of Training Units available. |
| 11 | LM_ITM_START_DT | Date(10) | DATE | TU Pool Item Start Date. |
| 12 | LM_ITM_END_DT | Date(10) | DATE | TU Pool Item End Date |
| 13 | LM_NO_OF_TUS | Number(14,3) | DECIMAL(13,3) NOT NULL | No of Training Units available/used. |
| 14 | LM_AMT_PAID | Number(23,3) | DECIMAL(22,3) NOT NULL | Amount Paid so far towards the Enrollment Fee |
| 15 | LM_ORG_TYPE | Character(15) | VARCHAR2(15) NOT NULL | Organization Type |