XML_TRN_ACTN_VW

(SQL View)
 Index Back

FT Actions for XML Reporting

Action Data View for Tripartite Foundation

SELECT B.COURSE , B.SESSION_NBR , A.TRN_T_ACTION_ESP , A.EFFDT , A.EFF_STATUS , A.DESCR , A.DESCRSHORT , A.TRN_T_LEVEL_ESP , 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 , C.TRN_T_MODALITY_ESP , C.TRN_T_TRNG_HR1_ESP , C.TRN_T_TRNG_HR2_ESP , C.TRN_T_TRNG_HR3_ESP , C.TRN_T_HOURS_ESP , 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_PASSWORD_ESP , D.COURSE_START_DT , D.COURSE_END_DT , 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_SESSN_ESP B , PS_TRN_T_ACT_WRK C , PS_CRSE_SESSN_TBL D WHERE A.TRN_T_ACTION_ESP = B.TRN_T_ACTION_ESP AND D.COURSE = B.COURSE AND D.SESSION_NBR = B.SESSION_NBR AND A.TRN_T_ACTION_ESP = C.TRN_T_ACTION_ESP AND A.EFFDT = C.EFFDT AND A.EFFDT = ( SELECT MAX(ED.EFFDT) FROM PS_TRN_T_ACT_ESP ED WHERE ED.EFFDT <= D.COURSE_START_DT AND ED.TRN_T_ACTION_ESP = A.TRN_T_ACTION_ESP)

# PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description
1 COURSE Character(6) VARCHAR2(6) NOT NULL Course Code
2 SESSION_NBR Character(4) VARCHAR2(4) NOT NULL Course Session Nbr
3 TRN_T_ACTION_ESP Character(5) VARCHAR2(5) NOT NULL Training Action
4 EFFDT Date(10) DATE NOT NULL Effective Date

Default Value: %date

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

Default Value: A

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

Default Value: B

9 TRN_T_TYP_CMP_ESP Character(1) VARCHAR2(1) NOT NULL Company
0=Organizing Entity Means
1=Benefited Company Means

Default Value: 1

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

Y/N Table Edit

Default Value: N

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

Y/N Table Edit

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

Y/N Table Edit

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

Y/N Table Edit

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

Y/N Table Edit

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

Default Value: INSTALLATION.COMPANY

Prompt Table: COMPANY_TBL

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

Y/N Table Edit

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

Y/N Table Edit

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

Y/N Table Edit

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

Y/N Table Edit

29 TRN_T_HRS_TECH_ESP Number(7,2) DECIMAL(6,2) NOT NULL Technology Module Hours
30 TRN_T_HRS_ENV_ESP Number(7,2) DECIMAL(6,2) NOT NULL Environment Module Hours
31 TRN_T_HRS_RISK_ESP Number(7,2) DECIMAL(6,2) NOT NULL Risk Prevention Module Hours
32 TRN_T_HRS_EQTY_ESP Number(7,2) DECIMAL(6,2) NOT NULL Equity Promotion Module Hours
33 TRN_T_RD_ESP Character(11) VARCHAR2(11) NOT NULL Law Id
34 TRN_T_ACT_CLSS_ESP Character(1) VARCHAR2(1) NOT NULL Action Class
0=Generic
1=Specific
35 TRN_T_USER_ESP Character(50) VARCHAR2(50) NOT NULL User
36 TRN_T_URL_ESP Character(254) VARCHAR2(254) NOT NULL URL
37 TRN_T_PASSWORD_ESP Character(20) VARCHAR2(20) NOT NULL Password
38 COURSE_START_DT Date(10) DATE Course Start Date
39 COURSE_END_DT Date(10) DATE Course End Date
40 TRN_T_OBJECTVS_ESP Character(254) VARCHAR2(254) NOT NULL Objectives
41 TRN_T_COMMENTS_ESP Character(254) VARCHAR2(254) NOT NULL Comments
42 TRN_T_CONTENTS_ESP Long Character CLOB Contents