EDIT_TMP_AET(SQL Table) |
Index Back |
|---|---|
Edit Sheet Temp AETThis table is used as a temporary working table in the Employee Survey process |
| # | PeopleSoft Field Name | PeopleSoft Field Type | Database Column Type | Description |
|---|---|---|---|---|
| 1 | PROCESS_INSTANCE | Number(10,0) | DECIMAL(10) NOT NULL | Process Instance |
| 2 | BILAN_STAT_CD_FRA | Character(3) | VARCHAR2(3) NOT NULL |
Social Bilan Category
ASC=Acting Executive CAD=Executive EMN=Non Qualified Worker EMQ=Qualified Worker TEC=Technician |
| 3 | EMPLID | Character(11) | VARCHAR2(11) NOT NULL | Employee ID |
| 4 | AE_BIND_VALUE_DT | Date(10) | DATE | Date |
| 5 | STD_HOURS | Number(7,2) | DECIMAL(6,2) NOT NULL | Standard Hours |
| 6 | FTE | Number(8,6) | DECIMAL(7,6) NOT NULL | This field represent Full Time Equivalence |