PGM_PROGRAM_TYPES

This table stores program types and program setting information.

Foreign Keys

This table does not have any foreign keys.

Column Descriptions

Column Name Null? Data Type Description
PROGRAM_TYPE_ID NOT NULL NUMBER System-generated ID for program type
VERSION NOT NULL NUMBER  
PROGRAM_TYPE_NAME NULLABLE VARCHAR2 (1) Name of the program type
DESCRIPTION NULLABLE VARCHAR2 (650) Description of the program type
ENABLED_FLAG NULLABLE VARCHAR2 (1) Flags whether the program type is enabled
PROG_TYPE_SETTINGS_KEY NULLABLE VARCHAR2 (32) System-generated version for the program type. This column must not be updated manually.
PROGRAM_REQUEST_TYPE_ID NULLABLE NUMBER Request ID of the program type
CREATED_BY NOT NULL NUMBER Creator of the program type
CREATION_DATE NOT NULL DATE Creation date of the program type
LAST_UPDATED_BY NOT NULL NUMBER User that last updated the program type
LAST_UPDATE_DATE NOT NULL DATE Date when the program type is last updated
ISSUE_REQUEST_TYPE_ID NULLABLE NUMBER ID of issue request type
RISK_REQUEST_TYPE_ID NULLABLE NUMBER ID of risk request type
RISK_REQUEST_TYPE_NAME NULLABLE VARCHAR2 (255) Name of risk request type
PROGRAM_REQUEST_TYPE_NAME NULLABLE VARCHAR2 (255) Request name of the program type
ISSUE_REQUEST_TYPE_NAME NULLABLE VARCHAR2 (255) Name of issue request type

Indexes

This table has no indexes.

Sequences

Sequence Name Sequence Type
PGM_PROGRAM_TYPES_S PROGRAM_TYPE_ID