| 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 |