XML_TRN_SESN_VW

(SQL View)
 Index Back

FT Session Data

Tripartite Foundation. Session Data for Reporting

SELECT A.COURSE , A.SESSION_NBR , A.TRN_T_ACTION_ESP , A.TRN_T_GROUP_ESP , C.DESCR100 , C.TRN_T_TYP_CMP_ESP , A.TRN_T_TYP_ENTI_ESP , C.TRN_T_TYP_CNTR_ESP , A.TRN_T_RSPNSBLE_ESP , A.PHONE , A.TRN_T_CHK_CNTR_ESP , A.TRN_T_STD_SESN_ESP , A.COMMENTS , D.COURSE_START_DT , D.COURSE_END_DT , A.TRN_T_ST_MRNG1_ESP , A.TRN_T_ET_MRNG1_ESP , A.TRN_T_ST_EVNG1_ESP , A.TRN_T_ET_EVNG1_ESP , A.TRN_T_TRNG_HR1_ESP , A.TRN_T_DAYS1_ESP , A.TRN_T_ST_MRNG2_ESP , A.TRN_T_ET_MRNG2_ESP , A.TRN_T_ST_EVNG2_ESP , A.TRN_T_ET_EVNG2_ESP , A.TRN_T_TRNG_HR2_ESP , A.TRN_T_DAYS2_ESP , A.TRN_T_ST_MRNG3_ESP , A.TRN_T_ET_MRNG3_ESP , A.TRN_T_ST_EVNG3_ESP , A.TRN_T_ET_EVNG3_ESP , A.TRN_T_TRNG_HR3_ESP , A.TRN_T_DAYS3_ESP , A.TRN_T_CHK_FNSH_ESP , A.TRN_T_BGN_CRS_ESP , A.TRN_T_END_CRS_ESP FROM PS_TRN_T_SESSN_ESP A , PS_TRN_T_ACT_ESP B , PS_TRN_T_GRP_ESP C , PS_CRSE_SESSN_TBL D WHERE B.TRN_T_ACTION_ESP = A.TRN_T_ACTION_ESP AND B.EFF_STATUS = 'A' AND %EffdtCheck(TRN_T_ACT_ESP EFFDT , B, %CurrentDateIn) AND C.TRN_T_ACTION_ESP = B.TRN_T_ACTION_ESP AND C.TRN_T_GROUP_ESP = A.TRN_T_GROUP_ESP AND C.EFFDT = B.EFFDT AND D.COURSE = A.COURSE AND D.SESSION_NBR = A.SESSION_NBR

# PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description
1 COURSE Character(6) VARCHAR2(6) NOT NULL Course Code

Prompt Table: CRSE_SESSN_SRCH

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

Prompt Table: TRN_T_ACT_ESP

4 TRN_T_GROUP_ESP Character(5) VARCHAR2(5) NOT NULL Training Group

Prompt Table: TRN_T_GRP_ESP

5 DESCR100 Character(100) VARCHAR2(100) NOT NULL Length 100 Description
6 TRN_T_TYP_CMP_ESP Character(1) VARCHAR2(1) NOT NULL Company
0=Organizing Entity Means
1=Benefited Company Means

Default Value: N

7 TRN_T_TYP_ENTI_ESP Character(1) VARCHAR2(1) NOT NULL Organizing Entity

Default Value: N

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

Y/N Table Edit

Default Value: N

9 TRN_T_RSPNSBLE_ESP Character(100) VARCHAR2(100) NOT NULL Responsible
10 PHONE Character(24) VARCHAR2(24) NOT NULL Telephone

Prompt Table: TRN_T_EE_PHN_VW

11 TRN_T_CHK_CNTR_ESP Character(1) VARCHAR2(1) NOT NULL Private Contribution
0=Bonificated Group
1=Private Contribution

Y/N Table Edit

Default Value: N

12 TRN_T_STD_SESN_ESP Number(3,0) SMALLINT NOT NULL Students/Session
13 COMMENTS Long Character CLOB Comment
14 COURSE_START_DT Date(10) DATE Course Start Date
15 COURSE_END_DT Date(10) DATE Course End Date
16 TRN_T_ST_MRNG1_ESP Time(15) TIMESTAMP Start Time Morning
17 TRN_T_ET_MRNG1_ESP Time(15) TIMESTAMP End Time Morning
18 TRN_T_ST_EVNG1_ESP Time(15) TIMESTAMP Start Time Evening
19 TRN_T_ET_EVNG1_ESP Time(15) TIMESTAMP End Time Evening
20 TRN_T_TRNG_HR1_ESP Number(7,2) DECIMAL(6,2) NOT NULL Training Hours
21 TRN_T_DAYS1_ESP Character(7) VARCHAR2(7) NOT NULL Days Of Week
22 TRN_T_ST_MRNG2_ESP Time(15) TIMESTAMP Start Time Morning
23 TRN_T_ET_MRNG2_ESP Time(15) TIMESTAMP End Time Morning
24 TRN_T_ST_EVNG2_ESP Time(15) TIMESTAMP Start Time Evening
25 TRN_T_ET_EVNG2_ESP Time(15) TIMESTAMP End Time Evening
26 TRN_T_TRNG_HR2_ESP Number(7,2) DECIMAL(6,2) NOT NULL Training Hours
27 TRN_T_DAYS2_ESP Character(7) VARCHAR2(7) NOT NULL Days Of Week
28 TRN_T_ST_MRNG3_ESP Time(15) TIMESTAMP Start Time Morning
29 TRN_T_ET_MRNG3_ESP Time(15) TIMESTAMP End Time Morning
30 TRN_T_ST_EVNG3_ESP Time(15) TIMESTAMP Start Time Evening
31 TRN_T_ET_EVNG3_ESP Time(15) TIMESTAMP End Time Evening
32 TRN_T_TRNG_HR3_ESP Number(7,2) DECIMAL(6,2) NOT NULL Training Hours
33 TRN_T_DAYS3_ESP Character(7) VARCHAR2(7) NOT NULL Days Of Week
34 TRN_T_CHK_FNSH_ESP Character(1) VARCHAR2(1) NOT NULL Finished
F=5 - Finished and Reported
I=2 - Initiated No Reported
N=1 - Defined / Approved
R=3 - Initiated and Reported
Y=4 - Finished No Reported

Y/N Table Edit

Default Value: N

35 TRN_T_BGN_CRS_ESP Date(10) DATE Start Date
36 TRN_T_END_CRS_ESP Date(10) DATE End Date