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 Columns 
ColumnName  Domain  Datatype  NULL  Definition 
RECURRENCE_CD(PK)    VARCHAR2(10)  NO 
Name: Recurrence Code. Description: The identifier for the recurrence code.
 
RECURRENCE_DESC    VARCHAR2(30)  NO 
Name: Recurrence Code Description. Description: The description for the recurrence code.
 
S_FREQUENCY_CD    VARCHAR2(1)  NO 
 
WEEKDAY_FL    VARCHAR2(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    VARCHAR2(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    NUMBER(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    VARCHAR2(20)  NO 
Name: Modified By. Description: The User ID of the person who last modified this record.
 
ROWVERSION    NUMBER(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    NUMBER(10, 0)  NO 
 

RECURRENCE Primary and Unique Keys 
Key Name  Key Type  Keys 
PI_0234  PrimaryKey  RECURRENCE_CD 

RECURRENCE Foreign Keys 
Parent Relationships: 
Table Name  Type  Cardinality  Constraint Name  VerbPhrase  InversePhrase  Foreign Keys  Is Supertype  Deferrable 
Child Relationships: 
Table Name  Type  Cardinality  Constraint Name  VerbPhrase  InversePhrase  Foreign Keys  Is Subtype  Deferrable 
SCHEDULED_PROCESS  Identifying  One To Zero or More  F00330        NO  NO