LM_PERSON_IDPrompt Table: LM_NAME_TYPE
Default Value: LM_LE_DFLT_TBL.LM_LE_ID
Prompt Table: LM_LE_VW
LM_SUPERVISR_VW(SQL View) |
Index Back |
|---|---|
Supervisor Viewcontains Internal People, used as prompt table for Supervisor |
| SELECT LM_PERSON_ID , LM_NAME_TYPE , NAME , LAST_NAME , FIRST_NAME , MIDDLE_NAME , LM_LE_ID , LM_EXT_PERSON_FLG , LM_NAME_DISPLAY FROM PS_LM_PERS_NAME_VW WHERE LM_EXT_PERSON_FLG = 'N' |
| # | 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_NAME_TYPE | Character(3) | VARCHAR2(3) NOT NULL |
Name Type
Prompt Table: LM_NAME_TYPE |
| 3 | NAME | Character(50) | VARCHAR2(50) NOT NULL | Name |
| 4 | LAST_NAME | Character(30) | VARCHAR2(30) NOT NULL | Last Name Field |
| 5 | FIRST_NAME | Character(30) | VARCHAR2(30) NOT NULL | First Name field |
| 6 | MIDDLE_NAME | Character(30) | VARCHAR2(30) NOT NULL | Middle Name |
| 7 | LM_LE_ID | Number(10,0) | DECIMAL(10) NOT NULL |
Learning Environment ID - System Generated number
Default Value: LM_LE_DFLT_TBL.LM_LE_ID Prompt Table: LM_LE_VW |
| 8 | LM_EXT_PERSON_FLG | Character(1) | VARCHAR2(1) NOT NULL | External Person Flag |
| 9 | LM_NAME_DISPLAY | Character(50) | VARCHAR2(50) NOT NULL | Name Display field |