| pcs_transition |
| Logical Entity Name | pcs_transition |
| Default Table Name | pcs_transition |
| Definition | Part of the pcs system. Stores a series of task. Used by PCS package |
| pcs_transition Attributes |
| Attribute/Logical Rolename | Domain | Datatype | NULL | Definition |
| GROUPOLD |
VARCHAR(20) | NO | ||
| SOURCEOLD |
VARCHAR(20) | NO | ||
| STATEOLD |
VARCHAR(20) | NO | ||
| RESULTOLD |
NUMERIC(0, 0) | NO | ||
| GROUPNEW |
VARCHAR(20) | NO | ||
| SOURCENEW |
VARCHAR(20) | NO | ||
| STATENEW |
VARCHAR(20) | NO | ||
| RANKNEW | NUMERIC(0, 0) | YES | ||
| RESULTNEW | NUMERIC(0, 0) | YES | ||
| AUTH | VARCHAR(15) | YES | ||
| SUBSOURCE | VARCHAR(8) | YES | ||
| LDDATE | DATE | YES |
| pcs_transition Keys |
| Key Name | Key Type | Keys |
| PCS_STATE_PK | PrimaryKey | GROUPOLD, SOURCEOLD, STATEOLD, RESULTOLD, GROUPNEW, SOURCENEW, STATENEW |
| pcs_transition 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_transition Check Constraints |
| Check Constraint Name | CheckConstraint |