LM_S4_RULE_COND(SQL Table) |
Index Back |
|---|---|
Sequencing rule conditions |
| # | PeopleSoft Field Name | PeopleSoft Field Type | Database Column Type | Description |
|---|---|---|---|---|
| 1 |  LM_S4_RULE_COND_ID |
Number(10,0) | DECIMAL(10) NOT NULL | Sequencing Rule Condition Id |
| 2 | LM_S4_SEQ_RULE_ID | Number(10,0) | DECIMAL(10) NOT NULL | Sequencing Rule Id |
| 3 | LM_S4_OBJV_ID | Number(10,0) | DECIMAL(10) NOT NULL | Objective Id |
| 4 | LM_S4_MEAS_THOLD | Signed Number(7,4) | DECIMAL(5,4) NOT NULL | Sequencing rule measure threshold |
| 5 | LM_S4_RULE_OP | Character(2) | VARCHAR2(2) NOT NULL |
Sequencing/Rollup Rule operator
10=noOp 20=not Default Value: 10 |
| 6 | LM_S4_RULE_CND_TYP | Character(2) | VARCHAR2(2) NOT NULL |
Sequencing Rule Condition type
05=satisfied 10=objectiveStatusKnown 15=objectiveMeasureKnown 20=objectiveMeasureGreaterThan 25=objectiveMeasureLessThan 30=completed 35=activityProgressKnown 40=attempted 45=attemptedLimitExceeded 50=timeLimitExceeded 55=outsideAvailableTimeRange 60=always 65=never |
| 7 | LM_ROW_ADDED_DTTM | DateTime(26) | TIMESTAMP | Datetime Added |
| 8 | LM_ROW_ADDED_OPRID | Character(30) | VARCHAR2(30) NOT NULL | Added By |
| 9 | LM_ROW_MAINT_DTTM | DateTime(26) | TIMESTAMP | Row Maintainted DateTime |
| 10 | LM_ROW_MAINT_OPRID | Character(30) | VARCHAR2(30) NOT NULL | Row Maintained Oprid |