LM_NATT_VW_LNG(SQL View) |
Index Back |
---|---|
Attendance SchemesRelated Language Record for Attendance Schemes |
SELECT LM_ATT_VAL_ID , LANGUAGE_CD , LM_ATT_STTS_LABEL FROM PS_LM_ATT_VAL_LANG |
# | PeopleSoft Field Name | PeopleSoft Field Type | Database Column Type | Description |
---|---|---|---|---|
1 | LM_WBT_NATT_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 Not 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 | LANGUAGE_CD | Character(3) | VARCHAR2(3) NOT NULL | Language Code |
3 | LM_ATT_STTS_LABEL | Character(30) | VARCHAR2(30) NOT NULL | Attendance Status Label |