TL_RULE_ELEMNT3(SQL Table) |
Index Back |
---|---|
Rule Element 3Rule Elements are customer definable fields for tracking employee activities that may impact rules processing. Time Reporting templates control whether or not this information is gathered in Time Reporting. Rule definitions determine whether or not to use this information during rules processing. |
# | PeopleSoft Field Name | PeopleSoft Field Type | Database Column Type | Description |
---|---|---|---|---|
1 | RULE_ELEMENT_3 | Character(10) | VARCHAR2(10) NOT NULL | Rule Element 3 |
2 | EFFDT | Date(10) | DATE NOT NULL |
Effective Date
Default Value: %date |
3 | EFF_STATUS | Character(1) | VARCHAR2(1) NOT NULL |
Effective Status
A=Active I=Inactive Default Value: A |
4 | DESCR | Character(30) | VARCHAR2(30) NOT NULL | Description |
5 | DESCRSHORT | Character(10) | VARCHAR2(10) NOT NULL |
Short Description
Default Value: TL_RULE_ELEMNT3.DESCR |