TRN_TUIT_REIMB(SQL Table) |
Index Back |
|---|---|
EE Training Expense ReimbUse TRN_TUIT_REIMB to record cost information for students who have applied to your company for tuition reimbursement for training courses completed or in progress. Courses can be either internal or external. Students can be either employees or non-employees. This functionality is part of the Training Administration application. You can create multiple TRN_TUIT_REIMB records for a student. |
| # | PeopleSoft Field Name | PeopleSoft Field Type | Database Column Type | Description |
|---|---|---|---|---|
| 1 |  EMPLID |
Character(11) | VARCHAR2(11) NOT NULL |
Employee ID
Prompt Table: PERSON |
| 2 | NON_EMPLOYEE_ID |
Character(11) | VARCHAR2(11) NOT NULL | Non-Employee ID |
| 3 | COURSE_START_DT |
Date(10) | DATE | Course Start Date |
| 4 | COURSE |
Character(6) | VARCHAR2(6) NOT NULL |
Course Code
Prompt Table: COURSE_TBL |
| 5 | SESSION_NBR |
Character(4) | VARCHAR2(4) NOT NULL |
Course Session Nbr
Prompt Table: CRSE_SESSN_TBL |
| 6 | COURSE_TITLE |
Character(30) | VARCHAR2(30) NOT NULL | Course Title |
| 7 | TUIT_EXPENSE_TYPE |
Character(10) | VARCHAR2(10) NOT NULL |
Tuition Expense Type
Prompt Table: TUIT_EXPEN_TBL |
| 8 | TUIT_EXPENSE_AMT | Number(19,3) | DECIMAL(18,3) NOT NULL | Expense Amount |
| 9 | TUIT_REIMB_AMT | Number(19,3) | DECIMAL(18,3) NOT NULL | Amount Reimbursed |
| 10 | CURRENCY_CD | Character(3) | VARCHAR2(3) NOT NULL |
Currency Code
Default Value: INSTALLATION.EXCHNG_TO_CURRENCY Prompt Table: CURRENCY_CD_TBL |
| 11 | TUIT_REIMB_DT | Date(10) | DATE NOT NULL | Reimbursement Date |
| 12 | WORK_RELATED | Character(1) | VARCHAR2(1) NOT NULL |
Work-Related
Y/N Table Edit Default Value: N |