PROCESS_INSTANCEBUSS=Business Unit
CNTR=Country
CUST=Customer
DEPT=Department
HIER=Department Hierarchy
JOBC=Job Code
LENV=Learning Environment
LOC=Location
LRNR=Learner
REGN=Region
Prompt Table: %EDITTABLE
LM_GROUP_AET(SQL Table) |
Index Back |
|---|---|
Learner Groups CriteriaLearner Groups Criteria |
| # | PeopleSoft Field Name | PeopleSoft Field Type | Database Column Type | Description |
|---|---|---|---|---|
| 1 | PROCESS_INSTANCE |
Number(10,0) | DECIMAL(10) NOT NULL | Process Instance |
| 2 | LM_LRNR_GROUP_ID | Number(15,0) | DECIMAL(15) NOT NULL | Learner Group ID - Business Role/ Student Group ID |
| 3 | LM_CRITERIA_ID | Number(10,0) | DECIMAL(10) NOT NULL | Learner Group Criteria ID |
| 4 | LM_CRITERIA_TYPE | Character(4) | VARCHAR2(4) NOT NULL |
Learner Group Criteria Type
BUSS=Business Unit CNTR=Country CUST=Customer DEPT=Department HIER=Department Hierarchy JOBC=Job Code LENV=Learning Environment LOC=Location LRNR=Learner REGN=Region |
| 5 | LM_CRITERIA_VALUE | Character(15) | VARCHAR2(15) NOT NULL |
Criteria Value
Prompt Table: %EDITTABLE |
| 6 | LM_ROW_ADDED_DTTM | DateTime(26) | TIMESTAMP | Datetime Added |
| 7 | LM_ROW_ADDED_OPRID | Character(30) | VARCHAR2(30) NOT NULL | Added By |
| 8 | LM_ROW_MAINT_DTTM | DateTime(26) | TIMESTAMP | Row Maintainted DateTime |
| 9 | LM_ROW_MAINT_OPRID | Character(30) | VARCHAR2(30) NOT NULL | Row Maintained Oprid |