TL_RULE_IDTL_RULE_STEPSEQ_NUMPrompt Table: TL_CONDITIONS
1=(
2=((
3=(((
4=((((
5=(((((
6=((((((
7=(((((((
1=)
2=))
3=)))
4=))))
5=)))))
6=))))))
7=)))))))
0=AND
1=OR
TL_RULE_CONDS(SQL Table) |
Index Back |
|---|---|
Time Admin Rule Conditions |
| # | PeopleSoft Field Name | PeopleSoft Field Type | Database Column Type | Description |
|---|---|---|---|---|
| 1 | TL_RULE_ID |
Character(12) | VARCHAR2(12) NOT NULL | Rule ID |
| 2 | TL_RULE_STEP |
Number(2,0) | SMALLINT NOT NULL | Rule Step |
| 3 | SEQ_NUM |
Number(3,0) | SMALLINT NOT NULL | Sequence |
| 4 | CONDITION_ID | Character(12) | VARCHAR2(12) NOT NULL |
Condition ID
Prompt Table: TL_CONDITIONS |
| 5 | LEFT_PAREN | Character(1) | VARCHAR2(1) NOT NULL |
Left Parenthesis
1=( 2=(( 3=((( 4=(((( 5=((((( 6=(((((( 7=((((((( |
| 6 | RIGHT_PAREN | Character(1) | VARCHAR2(1) NOT NULL |
Right Parenthesis
1=) 2=)) 3=))) 4=)))) 5=))))) 6=)))))) 7=))))))) |
| 7 | BOOLEAN_OPERATOR | Character(1) | VARCHAR2(1) NOT NULL |
AND\OR
0=AND 1=OR |