RECURRENCE 
Default Table Name  RECURRENCE 
Definition 
 Name: Recurrence Codes.     Description: This table contains the user defined recurrence codes that are used by the scheduled processes.
 

RECURRENCE Attributes 
Attribute/Logical Rolename  Domain  Datatype  NULL  Definition 
RECURRENCE_CD(PK)    VARCHAR(10)  NO 
Name: Recurrence Code. Description: The identifier for the recurrence code.
 
RECURRENCE_DESC    VARCHAR(30)  NO 
Name: Recurrence Code Description. Description: The description for the recurrence code.
 
S_FREQUENCY_CD    VARCHAR(1)  NO 
 
WEEKDAY_FL    VARCHAR(1)  NO 
Name: Weekday Flag. Description: Logical as to whether only weekdays are part of the recurrence. This setting is only used for “Daily” frequency.
 
S_DAILY_DOW_CD    VARCHAR(3)  NO 
Name: Day of Week Option. Description: The day of the week for the recurrence. This setting is only used for “Weekly” frequency. The valid values are: MON – Monday. TUE – Tuesday. WED – Wednesday. THU – Thursday. FRI – Friday. SAT – Saturday. SUN – Sunday
 
S_MONTH_DAY_CD    NUMERIC(10, 0)  NO 
Name: Day of Month Option. Description: The day each month for the recurrence. This setting is only used for “Monthly” frequency. The valid values are:1 to 31.. 
 
MODIFIED_BY    VARCHAR(20)  NO 
Name: Modified By. Description: The User ID of the person who last modified this record.
 
ROWVERSION    NUMERIC(10, 0)  NO 
Name: Row Version. Description: The number of times this record as been updated.
 
TIME_STAMP    DATE  NO 
Name: Time Stamp. Description: Date and time the record was last modified.
 
S_MIN_CD    NUMERIC(10, 0)  NO 
 

RECURRENCE Keys 
Key Name  Key Type  Keys 
PI_0234  PrimaryKey  RECURRENCE_CD 

RECURRENCE Relationships 
Parent Relationships: 
Entity Name  Type  Cardinality  Business Name  VerbPhrase  InversePhrase  Foreign Keys  Is Supertype 
Child Relationships: 
Entity Name  Type  Cardinality  Business Name  VerbPhrase  InversePhrase  Foreign Keys  Is Subtype 
SCHEDULED_PROCESS  Identifying  One To Zero or More          NO