PROCESS_INSTANCEBUSN=Business
CAMP=Campus
DORM=Dormitory
HOME=Home
OTHR=Other
TRN001_AET(SQL Table) |
Index Back |
|---|---|
Training Letters State RecordAdminister Training state record for HT_TRN001 application engine process used in the production of training letters. |
| # | PeopleSoft Field Name | PeopleSoft Field Type | Database Column Type | Description |
|---|---|---|---|---|
| 1 | PROCESS_INSTANCE |
Number(10,0) | DECIMAL(10) NOT NULL | Process Instance |
| 2 | RUN_CNTL_ID | Character(30) | VARCHAR2(30) NOT NULL | Run Control ID |
| 3 | FROMDATE | Date(10) | DATE | From Date |
| 4 | THRUDATE | Date(10) | DATE | End Date |
| 5 | COURSE_AND_DATE | Character(6) | VARCHAR2(6) NOT NULL | Course Code |
| 6 | FROMDATE_CRSE | Date(10) | DATE | From Date |
| 7 | THRUDATE_CRSE | Date(10) | DATE | Thru Date |
| 8 | COURSE | Character(6) | VARCHAR2(6) NOT NULL | Course Code |
| 9 | SESSION_NBR | Character(4) | VARCHAR2(4) NOT NULL | Course Session Nbr |
| 10 | EMPLID | Character(11) | VARCHAR2(11) NOT NULL | Employee ID |
| 11 | COURSE_START_DT | Date(10) | DATE | Course Start Date |
| 12 | COURSE_END_DT | Date(10) | DATE | Course End Date |
| 13 | SESSN_START_TIME | Time(15) | TIMESTAMP | Start Time |
| 14 | SESSN_END_TIME | Time(15) | TIMESTAMP | End Time |
| 15 | COURSE_TITLE | Character(30) | VARCHAR2(30) NOT NULL | Course Title |
| 16 | E_ADDR_TYPE | Character(4) | VARCHAR2(4) NOT NULL |
Email Address Type.
Note: Dorm long name has been updated as Dormitory as part of PI26 updates. And, the owner id of the field is updated to CC from HR.
BUSN=Business CAMP=Campus DORM=Dormitory HOME=Home OTHR=Other |
| 17 | CHAR_START_DT | Character(10) | VARCHAR2(10) NOT NULL | Session Start Date |
| 18 | CHAR_END_DT | Character(10) | VARCHAR2(10) NOT NULL | Session End Date |
| 19 | CHAR_START_TIME | Character(6) | VARCHAR2(6) NOT NULL | Session Start Time |
| 20 | CHAR_END_TIME | Character(6) | VARCHAR2(6) NOT NULL | Session End Time |