LM_PERSON_IDLM_EMPL_RCDEFFDTPrompt Table: LM_LE_VW
N=Inactive
Y=Active
Prompt Table: LM_JOBCD_ALL_VW
LM_PER_ATTAD_VW(SQL View) |
Index Back |
|---|---|
Person Attribute & Addres DataContains Person Attribute & Address data. |
| SELECT A.LM_PERSON_ID , A.LM_EMPL_RCD , A.EFFDT , A.LM_END_EFFDT , A.LM_LE_ID , A.LM_ORGANIZATION_ID , A.LM_ACTIVE , A.LM_JOBCODE_ID , A.BUSINESS_UNIT , A.LM_REG_REGION , A.LM_LOCATION_ID , B.COUNTRY FROM PS_LM_PERSON_ATTRB A LEFT OUTER JOIN PS_LM_PERSON_ADDR B ON ( B.LM_PERSON_ID = A.LM_PERSON_ID AND %CurrentDateIn BETWEEN B.EFFDT AND B.LM_END_EFFDT AND B.LM_PRIMARY = 'Y') WHERE A.LM_ACTIVE = 'Y' AND %CurrentDateIn BETWEEN A.EFFDT AND A.LM_END_EFFDT |
| # | 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_EMPL_RCD |
Number(3,0) | SMALLINT NOT NULL | Empl Record umber |
| 3 | EFFDT |
Date(10) | DATE NOT NULL | Effective Date |
| 4 | LM_END_EFFDT | Date(10) | DATE | The end effective date, automatically maintained, there's a doc on how this works, so read it |
| 5 | LM_LE_ID | Number(10,0) | DECIMAL(10) NOT NULL |
Learning Environment ID - System Generated number
Prompt Table: LM_LE_VW |
| 6 | LM_ORGANIZATION_ID | Number(15,0) | DECIMAL(15) NOT NULL | Organization ID |
| 7 | LM_ACTIVE | Character(1) | VARCHAR2(1) NOT NULL |
Active
N=Inactive Y=Active |
| 8 | LM_JOBCODE_ID | Number(15,0) | DECIMAL(15) NOT NULL |
JobCode ID
Prompt Table: LM_JOBCD_ALL_VW |
| 9 | BUSINESS_UNIT | Character(5) | VARCHAR2(5) NOT NULL | Business Unit |
| 10 | LM_REG_REGION | Character(5) | VARCHAR2(5) NOT NULL | Regulatory Region |
| 11 | LM_LOCATION_ID | Number(15,0) | DECIMAL(15) NOT NULL | Location Id |
| 12 | COUNTRY | Character(3) | VARCHAR2(3) NOT NULL | Country |