XML_TRN_ACTN_VW

(SQL View)
 Index Back

FT Actions for XML Reporting

Action Data View for Tripartite Foundation

SELECT A.TRN_T_ACTION_ESP , A.EFFDT , A.EFF_STATUS , A.DESCR , A.DESCRSHORT , CASE WHEN A.TRN_T_MODALITY_ESP <> '3' THEN A.TRN_T_LEVEL_ESP ELSE ' ' END , A.TRN_T_TYP_CMP_ESP , A.TRN_T_TYP_CNTR_ESP , A.TRN_T_PRESNTL_ESP , A.TRN_T_LONGDSTN_ESP , A.TRN_T_ONLINE_ESP , A.TRN_T_MIX_ESP , A.TRN_T_MODALITY_ESP , CASE WHEN A.TRN_T_MODALITY_ESP = '1' THEN A.TRN_T_TRNG_HR1_ESP ELSE 0 END , CASE WHEN A.TRN_T_MODALITY_ESP = '3' THEN A.TRN_T_TRNG_HR1_ESP ELSE 0 END , CASE WHEN A.TRN_T_MODALITY_ESP = '3' THEN A.TRN_T_TRNG_HR3_ESP ELSE 0 END , CASE WHEN A.TRN_T_MODALITY_ESP = '9' THEN A.TRN_T_TRNG_HR1_ESP ELSE 0 END , CASE WHEN A.TRN_T_MODALITY_ESP = '9' THEN A.TRN_T_TRNG_HR3_ESP ELSE 0 END , A.COMPANY , A.TRN_T_ACT_TYPE_ESP , A.TRN_T_ACTGRP_ESP , A.TRN_T_CERTIFCD_ESP , A.TRN_T_COMPTNCY_ESP , A.TRN_T_MOD_TECH_ESP , A.TRN_T_MOD_RISK_ESP , A.TRN_T_MOD_ENV_ESP , A.TRN_T_MOD_EQTY_ESP , C.TRN_T_HRS_TECH_ESP , C.TRN_T_HRS_ENV_ESP , C.TRN_T_HRS_RISK_ESP , C.TRN_T_HRS_EQTY_ESP , A.TRN_T_RD_ESP , A.TRN_T_ACT_CLSS_ESP , A.TRN_T_USER_ESP , A.TRN_T_URL_ESP , A.TRN_T_KEY_ESP , A.TRN_T_PRF_AREA_ESP , A.TRN_T_VENDOR2_ESP , A.TRN_T_OBJECTVS_ESP , A.TRN_T_COMMENTS_ESP , A.TRN_T_CONTENTS_ESP FROM PS_TRN_T_ACT_ESP A , PS_TRN_T_ACT_WRK C WHERE A.TRN_T_ACTION_ESP = C.TRN_T_ACTION_ESP AND A.EFFDT = C.EFFDT

# PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description
1 TRN_T_ACTION_ESP Character(5) VARCHAR2(5) NOT NULL Training Action
2 EFFDT Date(10) DATE NOT NULL Effective Date

Default Value: %date

3 EFF_STATUS Character(1) VARCHAR2(1) NOT NULL Effective Status
A=Active
I=Inactive

Default Value: A

4 DESCR Character(30) VARCHAR2(30) NOT NULL Description
5 DESCRSHORT Character(10) VARCHAR2(10) NOT NULL Short Description
6 TRN_T_LEVEL_ESP Character(1) VARCHAR2(1) NOT NULL Training Level
B=Basic
H=Higher

Default Value: B

7 TRN_T_TYP_CMP_ESP Character(1) VARCHAR2(1) NOT NULL Company
0=Organizing Entity
1=Bonif Company

Default Value: 1

8 TRN_T_TYP_CNTR_ESP Character(1) VARCHAR2(1) NOT NULL Studies Center

Y/N Table Edit

Default Value: N

9 TRN_T_PRESNTL_ESP Character(1) VARCHAR2(1) NOT NULL Presential

Y/N Table Edit

10 TRN_T_LONGDSTN_ESP Character(1) VARCHAR2(1) NOT NULL Long Distance

Y/N Table Edit

11 TRN_T_ONLINE_ESP Character(1) VARCHAR2(1) NOT NULL Tele Training

Y/N Table Edit

12 TRN_T_MIX_ESP Character(1) VARCHAR2(1) NOT NULL Mixed

Y/N Table Edit

13 TRN_T_MODALITY_ESP Character(1) VARCHAR2(1) NOT NULL Method Type
1=Presential
2=Long Distance
2=Long Distance
3=Internet
3=Tele-training
9=Mix
14 TRN_T_HOURS_ESP Number(7,2) DECIMAL(6,2) NOT NULL Presential Hours
15 TRN_T_TRNG_HR4_ESP Number(7,2) DECIMAL(6,2) NOT NULL Presential Hours
16 TRN_T_TRNG_HR2_ESP Number(7,2) DECIMAL(6,2) NOT NULL Training Hours
17 TRN_T_TRNG_HR1_ESP Number(7,2) DECIMAL(6,2) NOT NULL Presential Hours
18 TRN_T_TRNG_HR3_ESP Number(7,2) DECIMAL(6,2) NOT NULL Tele-training Hours
19 COMPANY Character(3) VARCHAR2(3) NOT NULL Company

Default Value: INSTALLATION.COMPANY

Prompt Table: COMPANY_TBL

20 TRN_T_ACT_TYPE_ESP Character(1) VARCHAR2(1) NOT NULL Action Type
C=Profesnl Qualif Catalog
I=Internal
21 TRN_T_ACTGRP_ESP Character(6) VARCHAR2(6) NOT NULL Group of Actions
22 TRN_T_CERTIFCD_ESP Character(8) VARCHAR2(8) NOT NULL Certification Code
23 TRN_T_COMPTNCY_ESP Character(7) VARCHAR2(7) NOT NULL Competency Unit
24 TRN_T_MOD_TECH_ESP Character(1) VARCHAR2(1) NOT NULL Information Technology

Y/N Table Edit

25 TRN_T_MOD_RISK_ESP Character(1) VARCHAR2(1) NOT NULL Occupational Risk Prevention

Y/N Table Edit

26 TRN_T_MOD_ENV_ESP Character(1) VARCHAR2(1) NOT NULL Environmental Awareness

Y/N Table Edit

27 TRN_T_MOD_EQTY_ESP Character(1) VARCHAR2(1) NOT NULL Equality Promotion

Y/N Table Edit

28 TRN_T_HRS_TECH_ESP Number(7,2) DECIMAL(6,2) NOT NULL Technology Module Hours
29 TRN_T_HRS_ENV_ESP Number(7,2) DECIMAL(6,2) NOT NULL Environment Module Hours
30 TRN_T_HRS_RISK_ESP Number(7,2) DECIMAL(6,2) NOT NULL Risk Prevention Module Hours
31 TRN_T_HRS_EQTY_ESP Number(7,2) DECIMAL(6,2) NOT NULL Equity Promotion Module Hours
32 TRN_T_RD_ESP Character(11) VARCHAR2(11) NOT NULL Law Id
33 TRN_T_ACT_CLSS_ESP Character(1) VARCHAR2(1) NOT NULL Action Class
0=Generic
1=Specific
34 TRN_T_USER_ESP Character(50) VARCHAR2(50) NOT NULL User
35 TRN_T_URL_ESP Character(254) VARCHAR2(254) NOT NULL URL
36 TRN_T_KEY_ESP Character(20) VARCHAR2(20) NOT NULL Key Code
37 TRN_T_PRF_AREA_ESP Character(4) VARCHAR2(4) NOT NULL Professional Area

Prompt Table: TRN_AREA_ESP_VW

38 TRN_T_VENDOR2_ESP Character(6) VARCHAR2(6) NOT NULL Vendor Id

Prompt Table: TRN_T_VND_ESPVW

39 TRN_T_OBJECTVS_ESP Character(254) VARCHAR2(254) NOT NULL Objectives
40 TRN_T_COMMENTS_ESP Character(254) VARCHAR2(254) NOT NULL Comments
41 TRN_T_CONTENTS_ESP Long Character CLOB Contents