LM_PERSON_IDCHAR=Character
DATE=Date
DEC=Decimal
LONG=Long Character
LM_LRNR_SRCH_I(SQL View) |
Index Back |
|---|---|
Learner Search ViewUsed for processing Learner Search Attributes |
| SELECT A.LM_PERSON_ID ,A.LM_ATTRIB_VAL_CHAR ,A.LM_ATTRIB_VAL_DEC ,A.LM_ATTRIB_VAL_DATE ,A.LM_ATTRIB_VAL_LONG ,B.LM_ATTRIB_NAME ,B.LM_ATTRIB_DATA_TYP FROM PS_LM_LRNR_ATTRIBS A ,PS_LM_ATTRIBS B WHERE A.LM_ATTRIB_NAME = B.LM_ATTRIB_NAME AND A.LM_ACTIVE = 'Y' AND B.LM_SRCH_ATTRIB='Y' |
| # | PeopleSoft Field Name | PeopleSoft Field Type | Database Column Type | Description |
|---|---|---|---|---|
| 1 | LM_PERSON_ID |
Number(15,0) | DECIMAL(15) NOT NULL | ELM Person ID |
| 2 | LM_ATTRIB_VAL_CHAR | Character(254) | VARCHAR2(254) NOT NULL | Attribute value |
| 3 | LM_ATTRIB_VAL_DEC | Number(32,6) | DECIMAL(31,6) NOT NULL | Decimal Attribut Value |
| 4 | LM_ATTRIB_VAL_DATE | Date(10) | DATE | Attribute Date Value |
| 5 | LM_ATTRIB_VAL_LONG | Long Character(54) | VARCHAR2(54) | Attibute Value |
| 6 | LM_ATTRIB_NAME | Character(30) | VARCHAR2(30) NOT NULL | Attribute Name |
| 7 | LM_ATTRIB_DATA_TYP | Character(4) | VARCHAR2(4) NOT NULL |
Attribute Data Type
CHAR=Character DATE=Date DEC=Decimal LONG=Long Character |