TRN_T_RC_EE_ESP(SQL Table) |
Index Back |
|---|---|
Tripartita Groups RC ESPTripartita Groups RC ESP |
| # | PeopleSoft Field Name | PeopleSoft Field Type | Database Column Type | Description |
|---|---|---|---|---|
| 1 |  OPRID |
Character(30) | VARCHAR2(30) NOT NULL |
A user's ID (see PSOPRDEFN).
Default Value: PSOPRDEFN.OPRID |
| 2 | RUN_CNTL_ID |
Character(30) | VARCHAR2(30) NOT NULL | Run Control ID |
| 3 | COURSE |
Character(6) | VARCHAR2(6) NOT NULL | Course Code |
| 4 | SESSION_NBR |
Character(4) | VARCHAR2(4) NOT NULL | Course Session Nbr |
| 5 | TRN_T_ACTION_ESP |
Character(5) | VARCHAR2(5) NOT NULL | Training Action |
| 6 | TRN_T_GROUP_ESP |
Character(5) | VARCHAR2(5) NOT NULL | Training Group |
| 7 | YEAR | Character(4) | VARCHAR2(4) NOT NULL | Character field to represent a year |
| 8 | TRN_T_BGN_CRS_ESP | Date(10) | DATE | Start Date |
| 9 | TRN_T_END_CRS_ESP | Date(10) | DATE | End Date |
| 10 | 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 |
| 11 | XML_NODE_ID | Character(6) | VARCHAR2(6) NOT NULL | Root node |
| 12 | TRN_T_TYP_CMP_ESP | Character(1) | VARCHAR2(1) NOT NULL |
Company
0=Organizing Entity 1=Bonif Company |
| 13 | EFFDT_FROM | Date(10) | DATE | Effective Date From |