XML_TRN_SESN_VW(SQL View) |
Index Back |
|---|---|
FT Session DataTripartite 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, D.COURSE_START_DT) 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 1=Bonif Company 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 Section 1 |
| 17 | TRN_T_ET_MRNG1_ESP | Time(15) | TIMESTAMP | End Time Section 1 |
| 18 | TRN_T_ST_EVNG1_ESP | Time(15) | TIMESTAMP | Start Time Section 2 |
| 19 | TRN_T_ET_EVNG1_ESP | Time(15) | TIMESTAMP | End Time Section 2 |
| 20 | TRN_T_TRNG_HR1_ESP | Number(7,2) | DECIMAL(6,2) NOT NULL | Presential 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 Section 1 |
| 23 | TRN_T_ET_MRNG2_ESP | Time(15) | TIMESTAMP | End Time Section 1 |
| 24 | TRN_T_ST_EVNG2_ESP | Time(15) | TIMESTAMP | Start Time Section 2 |
| 25 | TRN_T_ET_EVNG2_ESP | Time(15) | TIMESTAMP | End Time Section 2 |
| 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 Section 1 |
| 29 | TRN_T_ET_MRNG3_ESP | Time(15) | TIMESTAMP | End Time Section 1 |
| 30 | TRN_T_ST_EVNG3_ESP | Time(15) | TIMESTAMP | Start Time Section 2 |
| 31 | TRN_T_ET_EVNG3_ESP | Time(15) | TIMESTAMP | End Time Section 2 |
| 32 | TRN_T_TRNG_HR3_ESP | Number(7,2) | DECIMAL(6,2) NOT NULL | Tele-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 |