ATTENDANCE_PGM_IDEFFDTDefault Value: %date
ACTION_NBRDefault Value: 1
1=Verbal Warning
2=Letter to File
3=Written Warning 1
4=Written Warning 2
5=Suspension
6=Written Warning 3
7=Termination
8=Other
TL_ATTEND_ACT(SQL Table) |
Index Back |
|---|---|
Attendance Actions |
| # | PeopleSoft Field Name | PeopleSoft Field Type | Database Column Type | Description |
|---|---|---|---|---|
| 1 | ATTENDANCE_PGM_ID |
Character(10) | VARCHAR2(10) NOT NULL | Attendance Program |
| 2 | EFFDT |
Date(10) | DATE |
Effective Date
Default Value: %date |
| 3 | ACTION_NBR |
Number(3,0) | SMALLINT NOT NULL |
Action Number
Default Value: 1 |
| 4 | ATTENDANCE_ACTION | Character(2) | VARCHAR2(2) NOT NULL |
Attendance Action
1=Verbal Warning 2=Letter to File 3=Written Warning 1 4=Written Warning 2 5=Suspension 6=Written Warning 3 7=Termination 8=Other |
| 5 | COMMENTSHORT | Character(30) | VARCHAR2(30) NOT NULL | Short Comment |
| 6 | ATTEND_POINTS | Number(6,2) | DECIMAL(5,2) NOT NULL | Points |
| 7 | DAYS | Number(3,0) | SMALLINT NOT NULL | Days |