Share this page
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 |
| PROGRAM_TYPE_EDIT_ACCESS_ID | NULLABLE | NUMBER | Stores edit access information for the program type entity. It references securable_entity_id of the itg_securable_entities table. |
| PROGRAM_TYPE_USAGE_ID | NULLABLE | NUMBER | Stores usage access information for the program type. It references securable_entity_id of the itg_securable_entities table. |
Indexes
This table has no indexes.
Sequences
| Sequence Name | Sequence Type |
|---|---|
| PGM_PROGRAM_TYPES_S | PROGRAM_TYPE_ID |
