CST_PUBPROFILE (ver 15.5.1)
This table is a standalone table and stores profile information for the publishing framework. Note: Each entry must have a unique PROFILECODE. This table is available for all states/provinces and may or may not be utilized for your state/province.
Column Name | Version | Data Type | Description |
|---|---|---|---|
ID | 15.5.1 | NUMBER(19,0) | The internal ID for the CST_PUBPROFILE record to which the record is associated. Required. (Default – Next value in CST_PUBPROFILE_SQ sequence) |
PROFILECODE | 15.5.1 | VARCHAR2(10) | A unique code that identifies a profile. Required. |
PROFILENAME | 15.5.1 | VARCHAR2(100) | The name of the profile. Required. |
PROFILETYPECODE | 15.5.1 | VARCHAR2(30) | The general type of the profile (i.e. EDFI, SIF, etc). Required. |
PROFILETYPEVERSION | 15.5.1 | VARCHAR2(10) | The profile type version. Required. |
PACKAGENAME | 15.5.1 | VARCHAR2(30) | The PL/SQL package name used for profile specific general/common functionality. Required. |
UNIQUEIDPACKAGENAME | 15.5.1 | VARCHAR2(30) | The PL/SQL package name used for profile specific unique ID functionality. |
DOWNLOADPACKAGENAME | 15.5.1 | VARCHAR2(30) | The PL/SQL package name used for profile specific download functionality. |
VERSION | 15.5.1 | VARCHAR2(10) | The version of this profile. Required. |
ACTIVE (ver8.1.0) | 15.5.1 | NUMBER(1,0) | Specifies if the profile is active or enabled. (i.e. 0–Inactive/Disabled, 1–Active/Enabled) (Default - 1 or Active) |