LM_SELFREG_CNFG(SQL Table) |
Index Back |
---|---|
Self Registration ConfigParent record to store configuration id and other details on Self Registration Configuration page |
# | PeopleSoft Field Name | PeopleSoft Field Type | Database Column Type | Description |
---|---|---|---|---|
1 | LM_CONFIG_ID | Number(3,0) | SMALLINT NOT NULL |
Configuration ID
Default Value: 1 |
2 | LM_LE_ID | Number(10,0) | DECIMAL(10) NOT NULL |
Learning Environment ID - System Generated number
Prompt Table: LM_LE_VW |
3 | OPRID | Character(30) | VARCHAR2(30) NOT NULL |
A user's ID (see PSOPRDEFN).
Prompt Table: LM_OPRIDDESC_VW |
4 | DEFAULTUSERID | Character(30) | VARCHAR2(30) NOT NULL |
Public User ID
Prompt Table: LM_OPRIDDESC_VW |
5 | LM_ALTCHAR_FLG | Character(3) | VARCHAR2(3) NOT NULL |
Display Alternate Character Options
10=None 20=Names 30=Addresses 40=Names & Addresses Default Value: 10 |
6 | LM_DISPLY_NM_FMT | Character(1) | VARCHAR2(1) NOT NULL |
Display Name Format Yes/No Flag
N=No Y=Yes Y/N Table Edit Default Value: N |
7 | LM_LRNR_GROUP_FLG | Character(1) | VARCHAR2(1) NOT NULL |
Learner Group Flag
N=No Y=Yes Y/N Table Edit Default Value: N |