PSC_COM_EXPIRATION_RULE_F
This table contains the detail line expiration rules setup.
Details
-
Schema: FUSION
-
Object owner: PSC_CC
-
Object type: TABLE
-
Tablespace: Default
Primary Key
| Name | Columns |
|---|---|
|
PSC_COM_EXPIRATION_RULE_F_PK |
AGENCY_ID, EXPIRATION_GROUP_ID, EFFECTIVE_START_DATE, EFFECTIVE_END_DATE, EXPIRATION_BASIS |
Columns
| Name | Datatype | Length | Precision | Not-null | Comments |
|---|---|---|---|---|---|
| AGENCY_ID | NUMBER | 8 | Yes | This column is used to indicate agency id. | |
| EXPIRATION_GROUP_ID | VARCHAR2 | 50 | Yes | A unique name that identifies an Expiration Rule Group. | |
| EFFECTIVE_START_DATE | DATE | Yes | Date Effective Entity: indicates the date at the beginning of the date range within which the row is effective. | ||
| EFFECTIVE_END_DATE | DATE | Yes | Date Effective Entity: indicates the date at the end of the date range within which the row is effective. | ||
| EXPIRATION_BASIS | VARCHAR2 | 10 | Yes | The period range that is the basis for the expiration rule. | |
| RULE_SEQUENCE | NUMBER | 10 | Yes | The sequence number for the expiration rule. | |
| ENABLED_FLAG | VARCHAR2 | 1 | Yes | Indicates if the configuration is enabled. | |
| EXPIRATION_DURATION | NUMBER | 10 | Number indicating the expiration duration. | ||
| EXPIRATION_DUR_UOM | VARCHAR2 | 5 | Expiration duration unit of measure. | ||
| ATE_DURATION | NUMBER | 10 | Number indicating the about to expire duration. | ||
| ATE_DUR_UOM | VARCHAR2 | 5 | About to expire duration unit of measure. | ||
| GRACE_PERIOD | NUMBER | 10 | Number indicating the grace period duration. | ||
| GRACE_PERIOD_UOM | VARCHAR2 | 5 | Grace period duration unit of measure. | ||
| NUM_EXTENSIONS | NUMBER | 4 | Number of extensions allowed for the expiration rule. | ||
| INS_AUTO_EXTEND_FLAG | VARCHAR2 | 1 | Indicates that the expiration date will be auto-extended for inspection activities. | ||
| INS_RESULT_OPTION | VARCHAR2 | 10 | Indicates the inspection result required to extend. | ||
| INS_DURATION_EXTEND | NUMBER | 10 | Indicates the duration to extend the expiration. | ||
| INS_DURATION_EXTEND_UOM | VARCHAR2 | 5 | Indicates the duration unit of measure to extend. | ||
| INS_COMMENCEMENT_OPTION | VARCHAR2 | 10 | Indicates the inspection date used to determine the expiration period. | ||
| COMM_ATE_FLAG | VARCHAR2 | 1 | Indicates that communications will be sent for when about to expire. | ||
| COMM_ATE_FREQUENCY | VARCHAR2 | 5 | Indicates the frequency option when sending about to expire communications. | ||
| COMM_ATE_FREQ_DURATION | NUMBER | 10 | Indicates the frequency when sending about to expire communications. | ||
| COMM_ATE_MAX_FREQ | NUMBER | 5 | Indicates the maximum number of about to expire communications sent. | ||
| COMM_EXPIRE_FLAG | VARCHAR2 | 1 | Indicates that communications will be sent for when about to expire. | ||
| COMM_EXPIRE_FREQUENCY | VARCHAR2 | 5 | Indicates the frequency option when sending expiration communications. | ||
| COMM_EXPIRE_FREQ_DURATION | NUMBER | 10 | Indicates the frequency when sending expiration communications. | ||
| COMM_EXPIRE_MAX_FREQ | NUMBER | 5 | Indicates the maximum number of expiration communications sent. | ||
| INS_COMMENCEMENT_DATE_OPTION | VARCHAR2 | 30 | Commencement date option of the initial inspection. | ||
| INS_COMMENCEMENT_DURATION | NUMBER | 10 | Number indicating the inspection commencement duration. | ||
| INS_COMMENCEMENT_DURATION_UOM | VARCHAR2 | 5 | Inspection commencement duration unit of measure. | ||
| INS_COMM_AUTO_EXPIRE_FLAG | VARCHAR2 | 1 | Indicates that the expiration date will be auto-expired for inspection activities. | ||
| EXP_INTERVAL_DURATION | NUMBER | 5 | Number indicating the Expiration interval duration. | ||
| EXP_INTERVAL_DURATION_UOM | VARCHAR2 | 10 | Expiration interval duration unit of measure. | ||
| COMM_DELINQ_FLAG | VARCHAR2 | 1 | Indicates that communications will be sent for when delinquent. | ||
| COMM_DELINQ_FREQUENCY | VARCHAR2 | 5 | Indicates the frequency option when sending delinquent communications. | ||
| COMM_DELINQ_FREQ_DURATION | NUMBER | 10 | Indicates the frequency duration when sending delinquent communications. | ||
| COMM_DELINQ_MAX_FREQ | NUMBER | 5 | Indicates the maximum frequency duration when sending delinquent communications. | ||
| EXP_RECALC_REISSUE_FLAG | VARCHAR2 | 1 | Indicates that Permit should recalculate expiration date based on permit reissue date. | ||
| OBJECT_VERSION_NUMBER | NUMBER | 9 | Yes | Used to implement optimistic locking. This number is incremented every time that the row is updated. The number is compared at the start and end of a transaction to detect whether another session has updated the row since it was queried. | |
| CREATED_BY | VARCHAR2 | 64 | Yes | Who column: indicates the user who created the row. | |
| CREATION_DATE | TIMESTAMP | Yes | Who column: indicates the date and time of the creation of the row. | ||
| LAST_UPDATED_BY | VARCHAR2 | 64 | Yes | Who column: indicates the user who last updated the row. | |
| LAST_UPDATE_DATE | TIMESTAMP | Yes | Who column: indicates the date and time of the last update of the row. | ||
| LAST_UPDATE_LOGIN | VARCHAR2 | 32 | Who column: indicates the session login associated to the user who last updated the row. |
Foreign Keys
| Table | Foreign Table | Foreign Key Column |
|---|---|---|
| PSC_COM_EXPIRATION_RULE_F | psc_com_exp_group_f_b | AGENCY_ID, EXPIRATION_GROUP_ID, EFFECTIVE_START_DATE, EFFECTIVE_END_DATE |
Indexes
| Index | Uniqueness | Tablespace | Columns |
|---|---|---|---|
| PSC_COM_EXPIRATION_RULE_F_PK | Unique | Default | AGENCY_ID, EXPIRATION_GROUP_ID, EFFECTIVE_START_DATE, EFFECTIVE_END_DATE, EXPIRATION_BASIS |