pcs_state

Logical Entity Name | pcs_state
Default Table Name | pcs_state
Definition | Part of the pcs system. Stores state of a task. Used by PCS package

pcs_state Attributes

Attribute/Logical Rolename | Domain | Datatype | NULL | Definition
CONTROLGROUP |  | VARCHAR(20) | NO |
SOURCETABLE |  | VARCHAR(20) | NO |
ID |  | NUMERIC(0, 0) | NO |
STATE |  | VARCHAR(20) | NO |
RANK |  | NUMERIC(0, 0) | NO |
RESULT |  | NUMERIC(0, 0) | YES |
SECONDARYID |  | NUMERIC(0, 0) | YES |
SECONDARYSOURCETABLE |  | VARCHAR(20) | YES |
AUTH |  | VARCHAR(15) | YES |
SUBSOURCE |  | VARCHAR(8) | YES |
LDDATE |  | DATE | YES |

pcs_state Keys

Key Name | Key Type | Keys
PK14 | PrimaryKey | CONTROLGROUP, SOURCETABLE, ID, STATE

pcs_state Relationships

Parent Relationships:

Entity Name | Type | Cardinality | Business Name | VerbPhrase | InversePhrase | Foreign Keys | Is Supertype

Child Relationships:

Entity Name | Type | Cardinality | Business Name | VerbPhrase | InversePhrase | Foreign Keys | Is Subtype

pcs_state Check Constraints

Check Constraint Name | CheckConstraint