LM_LRQ_IDLM_ACCESS_OPTION01=Wheelchair Access
02=Hearing Impaired
03=Other
04=Vision Impaired
LM_LRQACCESS_VW(SQL View) |
Index Back |
|---|---|
View for special requestsView for special requests of a learning request |
| SELECT A.LM_LRQ_ID , A.LM_ACCESS_OPTION , B.XLATLONGNAME FROM PS_LM_LRQ_ACCESS A , PSXLATITEM B WHERE A.LM_ACCESS_OPTION = FIELDVALUE AND B.FIELDNAME = 'LM_ACCESS_OPTION' |
| # | PeopleSoft Field Name | PeopleSoft Field Type | Database Column Type | Description |
|---|---|---|---|---|
| 1 | LM_LRQ_ID |
Number(10,0) | DECIMAL(10) NOT NULL | New field for ELM 9.0, stores unique identifier for a single learning request. |
| 2 | LM_ACCESS_OPTION |
Character(2) | VARCHAR2(2) NOT NULL |
Accessibility Option
01=Wheelchair Access 02=Hearing Impaired 03=Other 04=Vision Impaired |
| 3 | XLATLONGNAME | Character(30) | VARCHAR2(30) NOT NULL | Translate Long Name |