LM_LRQACCESS_VW

(SQL View)
Index Back

View for special requests

View 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'

  • Related Language Record: LM_LRQACCES_LVW
  • # 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