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 |