1. Tables and Views
  2. PSC_INS_INSPECTION_CAL_B

PSC_INS_INSPECTION_CAL_B

This table contains inspection calendar information.

Details

  • Schema: FUSION

  • Object owner: PSC_PER

  • Object type: TABLE

  • Tablespace: TRANSACTION_TABLES

Primary Key

Name Columns

PSC_INS_INSPECTION_CAL_B_PK

CALENDAR_ID, AGENCY_ID, INSPECTION_TYPE, DISTRICT_ID

Columns

Name Datatype Length Precision Not-null Comments Status
CALENDAR_ID VARCHAR2 30 Yes Unique identifier for the Inspection Calendar. Active
AGENCY_ID NUMBER 8 Yes Attribute identifying the agency associated with the row. Active
INSPECTION_TYPE VARCHAR2 15 Yes Inspection Type associated with the Inspection Calendar. Active
DISTRICT_ID VARCHAR2 30 Yes District associated with the Inspection Calendar. Active
VALID_FROM_DATE DATE Yes Start date for the Inspection Calendar. Active
VALID_TO_DATE DATE Yes End date for the Inspection Calendar. Active
TIME_FROM TIMESTAMP Yes Start time for the Inspection Calendar. Active
TIME_TO TIMESTAMP Yes End time for the Inspection Calendar. Active
RECURRENCE VARCHAR2 3 Recurrence option, None or Weekly. Active
BETW_RECUR_NUM NUMBER 2 Number of weeks between occurrences. Active
SUN_FLAG VARCHAR2 1 Yes Enabled if the calendar is effective on Sunday. Active
MON_FLAG VARCHAR2 1 Yes Enabled if the calendar is effective on Monday. Active
TUE_FLAG VARCHAR2 1 Yes Enabled if the calendar is effective on Tuesday. Active
WED_FLAG VARCHAR2 1 Yes Enabled if the calendar is effective on Wednesday. Active
THU_FLAG VARCHAR2 1 Yes Enabled if the calendar is effective on Thursday. Active
FRI_FLAG VARCHAR2 1 Yes Enabled if the calendar is effective on Friday. Active
SAT_FLAG VARCHAR2 1 Yes Enabled if the calendar is effective on Saturday. Active
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. Active
CREATED_BY VARCHAR2 64 Yes Who column: indicates the user who created the row. Active
CREATION_DATE TIMESTAMP Yes Who column: indicates the date and time of the creation of the row. Active
LAST_UPDATED_BY VARCHAR2 64 Yes Who column: indicates the user who last updated the row. Active
LAST_UPDATE_DATE TIMESTAMP Yes Who column: indicates the date and time of the last update of the row. Active
LAST_UPDATE_LOGIN VARCHAR2 32 Who column: indicates the session login associated to the user who last updated the row. Active
MODULE_ID VARCHAR2 32 Seed Data Framework: indicates the module that owns the row. A module is an entry in Application Taxonomy such as a Logical Business Area. When the MODULE_ID column exists and the owner of the row is not specified, then the Seed Data Framework will not extract the row as seed data. Active

Foreign Keys

Table Foreign Table Foreign Key Column
psc_ins_inspection_cal_tl psc_ins_inspection_cal_b CALENDAR_ID, AGENCY_ID, INSPECTION_TYPE, DISTRICT_ID

Indexes

Index Uniqueness Tablespace Columns Status
PSC_INS_INSPECTION_CAL_B_PK Unique Default CALENDAR_ID, AGENCY_ID, INSPECTION_TYPE, DISTRICT_ID Active