EE_IPE_STEPS(SQL Table) |
Index Back |
|---|---|
Employe IPE StepsEmploye Internal Professional Education Steps |
| # | PeopleSoft Field Name | PeopleSoft Field Type | Database Column Type | Description |
|---|---|---|---|---|
| 1 |  EMPLID |
Character(11) | VARCHAR2(11) NOT NULL | Employee ID |
| 2 | EMPL_RCD |
Number(3,0) | SMALLINT NOT NULL | Empl Rcd Nbr |
| 3 | DEGREE |
Character(8) | VARCHAR2(8) NOT NULL | Degree |
| 4 | STEP_ID |
Character(6) | VARCHAR2(6) NOT NULL |
Step ID
Prompt Table: IPE_STEP_TABLE |
| 5 | FROM_DT | Date(10) | DATE | From Date |
| 6 | THRU_DATE | Date(10) | DATE | Thru Date |
| 7 | IPE_STEP_STATUS | Character(2) | VARCHAR2(2) NOT NULL |
Step Status
A=Attending C=Completed LA=Logbook Available LC=Logbook Checked P=Planned |
| 8 | DEPTID | Character(10) | VARCHAR2(10) NOT NULL |
Department
Prompt Table: DEPT_TBL |
| 9 | SCHOOL_CODE | Character(10) | VARCHAR2(10) NOT NULL |
School Code
Prompt Table: SCHOOL_TBL_VW2 |
| 10 | EXT_IPE_STEPS | Character(50) | VARCHAR2(50) NOT NULL | External |
| 11 | BUSINESS_UNIT | Character(5) | VARCHAR2(5) NOT NULL |
Business Unit
Default Value: JOB_CURR_VW.BUSINESS_UNIT Prompt Table: BUS_UNIT_TBL_HR |