ATTENDANCE_PGM_IDEFFDTDefault Value: %date
Default Value: TL_ATTEND_PGM.DESCR
1=Fixed Period
2=Rolling Period
3=Step Period
Prompt Table: %EDITTABLE
Y/N Table Edit
Y/N Table Edit
Y/N Table Edit
Y/N Table Edit
TL_ATTEND_PGM(SQL Table) |
Index Back |
|---|---|
Attendance Program |
| # | 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 NOT NULL |
Effective Date
Default Value: %date |
| 3 | DESCR | Character(30) | VARCHAR2(30) NOT NULL | Description |
| 4 | DESCRSHORT | Character(10) | VARCHAR2(10) NOT NULL |
Short Description
Default Value: TL_ATTEND_PGM.DESCR |
| 5 | TRACKING_METHOD | Character(1) | VARCHAR2(1) NOT NULL |
Tracking Method
1=Fixed Period 2=Rolling Period 3=Step Period |
| 6 | PERIOD_ID | Character(12) | VARCHAR2(12) NOT NULL |
Time Period ID
Prompt Table: %EDITTABLE |
| 7 | TRACK_IN | Character(1) | VARCHAR2(1) NOT NULL |
Track Tardies
Y/N Table Edit |
| 8 | TRACK_MEAL | Character(1) | VARCHAR2(1) NOT NULL |
Track Long Lunch
Y/N Table Edit |
| 9 | MINUTES_MEAL | Number(3,0) | SMALLINT NOT NULL | Meal Duration (Minutes) |
| 10 | TRACK_OUT | Character(1) | VARCHAR2(1) NOT NULL |
Track Early Out
Y/N Table Edit |
| 11 | TRACK_BREAK | Character(1) | VARCHAR2(1) NOT NULL |
Track Long Break
Y/N Table Edit |
| 12 | MINUTES_BREAK | Number(3,0) | SMALLINT NOT NULL | Break Duration (Minutes) |
| 13 | GRACE_IN | Number(3,0) | SMALLINT NOT NULL | Grace (Minutes) |
| 14 | GRACE_MEAL | Number(2,0) | SMALLINT NOT NULL | Grace (Minutes) |
| 15 | GRACE_OUT | Number(3,0) | SMALLINT NOT NULL | Grace (Minutes) |
| 16 | GRACE_BREAK | Number(2,0) | SMALLINT NOT NULL | Grace (Minutes) |
| 17 | POINTS_IN | Number(6,2) | DECIMAL(5,2) NOT NULL | Tardy Points |
| 18 | POINTS_MEAL | Number(6,2) | DECIMAL(5,2) NOT NULL | Long Lunch Points |
| 19 | POINTS_OUT | Number(6,2) | DECIMAL(5,2) NOT NULL | Early Outk Points |
| 20 | POINTS_BREAK | Number(6,2) | DECIMAL(5,2) NOT NULL | Long Break Points |