PROCESS_INSTANCEEMPLIDCOURSE_START_DTCOURSESESSION_NBRCOURSE_TITLEE_ADDR_TYPEBUSN=Business
CAMP=Campus
DORM=Dormitory
HOME=Home
OTHR=Other
Y/N Table Edit
Default Value: N
TRN001_TAO(SQL Table) |
Index Back |
|---|---|
Temp record for HR_TRN001Administer Training - Temporary table 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 | EMPLID |
Character(11) | VARCHAR2(11) NOT NULL | Employee ID |
| 3 | COURSE_START_DT |
Date(10) | DATE | Course Start Date |
| 4 | COURSE |
Character(6) | VARCHAR2(6) NOT NULL | Course Code |
| 5 | SESSION_NBR |
Character(4) | VARCHAR2(4) NOT NULL | Course Session Nbr |
| 6 | COURSE_TITLE |
Character(30) | VARCHAR2(30) NOT NULL | Course Title |
| 7 | 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 |
| 8 | EMAIL_ADDR | Character(70) | VARCHAR2(70) NOT NULL | Email Address |
| 9 | COURSE_END_DT | Date(10) | DATE | Course End Date |
| 10 | SESSN_START_TIME | Time(15) | TIMESTAMP | Start Time |
| 11 | SESSN_END_TIME | Time(15) | TIMESTAMP | End Time |
| 12 | LETTER_CD | Character(3) | VARCHAR2(3) NOT NULL | Letter code |
| 13 | TRN001_AE_SW | Character(1) | VARCHAR2(1) NOT NULL |
Updated by Application Engine?
Y/N Table Edit Default Value: N |
| 14 | CHAR_START_DT | Character(10) | VARCHAR2(10) NOT NULL | Session Start Date |
| 15 | CHAR_END_DT | Character(10) | VARCHAR2(10) NOT NULL | Session End Date |
| 16 | CHAR_START_TIME | Character(6) | VARCHAR2(6) NOT NULL | Session Start Time |
| 17 | CHAR_END_TIME | Character(6) | VARCHAR2(6) NOT NULL | Session End Time |