PSC_LNP_ATTACHMENT

Details

Schema: FUSION
Object owner: PSC_PER
Object type: TABLE
Tablespace: TRANSACTION_TABLES

Primary Key

Name	Columns
PSC_LNP_ATTACHMENT_PK	LNP_ATTACHMENT_KEY

Columns

Name	Datatype	Length	Precision	Not-null	Comments	Status
LNP_RECORD_KEY	NUMBER		18	Yes	This column is used to indicate lnp record key	Active
RECORD_NUMBER	VARCHAR2	64		Yes	Alternate key and public unique identifier for a permit record.
ATTACHMENT_ID	NUMBER		18	Yes	This column is used to indicate attachment id	Active
DOC_CATEGORY	VARCHAR2	30			This column is used to indicate doc category	Active
DOC_SUBCATEGORY	VARCHAR2	30			This column is used to indicate doc subcategory	Active
PLAN_REVIEW_FLAG	VARCHAR2	1		Yes	This column is used to indicate plan review flag	Active
DIGITAL_SIGNATURE_FLAG	VARCHAR2	1		Yes	This column is used to indicate digital signature flag	Active
SUBJECT_ID	VARCHAR2	30			This column is used to indicate subject id	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
LNP_ATTACHMENT_KEY	NUMBER		18	Yes	Attribute identifying the product attachment key associated with the row.
LNP_ATTACHMENT_PUID	VARCHAR2	480		Yes	Public unique identifier for an attachment record.
AGENCY_ID	NUMBER		8	Yes	Attribute identifying the agency associated with the row.	Active
DOCUMENT_REVIEWED_FLAG	VARCHAR2	1		Yes	Used to indicate that the document was reviewed and returned from the third-party application.
DOC_GROUP_ID	VARCHAR2	30			Used to indicate the document group id for the attachment.
MIGRATED_DATA_FLAG	VARCHAR2	3			Indicates whether the record was migrated.
REVISED_DOC_UPLOADED_FLAG	VARCHAR2	1		Yes	Indicates whether the document is a revision.
FINAL_DOCUMENT_FLAG	VARCHAR2	1		Yes	Indicates the document is the final document for a plan review.
WRITE_PROTECTED_FLAG	VARCHAR2	1		Yes	Used to indicate that the document is a protected file.
PROTECTION_LEVEL	VARCHAR2	1		Yes	Used to indicate the type of protection for the document.
SUBMITTED_EVENT_FLAG	VARCHAR2	1		Yes	Indicates if an attachment is required referencing the document category when a permit is submitted.
ACCEPTED_EVENT_FLAG	VARCHAR2	1		Yes	Indicates if an attachment is required referencing the document category when a permit is accepted.
ISSUED_EVENT_FLAG	VARCHAR2	1		Yes	Indicates if an attachment is required referencing the document category when a permit is issued.
FINAL_INSPECTION_EVENT_FLAG	VARCHAR2	1		Yes	Indicates if an attachment is required referencing the document category when a final inspection is added.
COMPLETED_EVENT_FLAG	VARCHAR2	1		Yes	Indicates if an attachment is required referencing the document category when a permit is completed.

Foreign Keys

Table	Foreign Table	Foreign Key Column
PSC_LNP_ATTACHMENT	psc_lnp_record	LNP_RECORD_KEY

Indexes

Index	Uniqueness	Tablespace	Columns	Status
PSC_LNP_ATTACHMENT_FK1	Non Unique	FUSION_TS_TX_IDX	LNP_RECORD_KEY	Active
PSC_LNP_ATTACHMENT_N1	Non Unique	Default	ATTACHMENT_ID
PSC_LNP_ATTACHMENT_U1	Unique	Default	LNP_ATTACHMENT_KEY
PSC_LNP_ATTACHMENT_U2	Unique	Default	LNP_ATTACHMENT_PUID