LM_W_ATT_SCH_VW(SQL View) |
Index Back |
---|---|
Attendance SchemesAttendance Scheme Values |
SELECT LM_ATT_VAL_ID , LM_ATT_STTS_LABEL FROM PS_LM_ATT_SCH_VAL WHERE LM_ATT_STTS = 'ATTD' |
# | PeopleSoft Field Name | PeopleSoft Field Type | Database Column Type | Description |
---|---|---|---|---|
1 | LM_WBT_ATT_SCHEME | Number(10,0) | DECIMAL(10) NOT NULL | This is one of the labels defined in the Attendance Schemes. This default is used by the Auto Attendance Batch job while marking Enrollments as Attended for those Enrollments whose target date has passed or the WBT is Concluded (whichever comes earlier).Attendance Schemes are setup at the System Level. A user can customize these labels against various Attendance Statuses. |
2 | LM_ATT_STTS_LABEL | Character(30) | VARCHAR2(30) NOT NULL | Attendance Status Label |