| 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 Columns |
| ColumnName | Domain | Datatype | NULL | Definition |
| groupold |
VARCHAR2(20) | NO | ||
| sourceold |
VARCHAR2(20) | NO | ||
| stateold |
VARCHAR2(20) | NO | ||
| resultold |
NUMBER | NO | ||
| groupnew |
VARCHAR2(20) | NO | ||
| sourcenew |
VARCHAR2(20) | NO | ||
| statenew |
VARCHAR2(20) | NO | ||
| ranknew | NUMBER | YES | ||
| resultnew | NUMBER | YES | ||
| auth | VARCHAR2(15) | YES | ||
| subsource | VARCHAR2(8) | YES | ||
| lddate | DATE | YES |
| pcs_transition Primary and Unique Keys |
| Key Name | Key Type | Keys |
| pcs_state_pk | PrimaryKey | groupold, sourceold, stateold, resultold, groupnew, sourcenew, statenew |
| pcs_transition Foreign Keys |
| Parent Relationships: |
| Table Name | Type | Cardinality | Constraint Name | VerbPhrase | InversePhrase | Foreign Keys | Is Supertype | Deferrable | Initially Deferred |
| Child Relationships: |
| Table Name | Type | Cardinality | Constraint Name | VerbPhrase | InversePhrase | Foreign Keys | Is Subtype | Deferrable | Initially Deferred |
| pcs_transition Check Constraints |
| Check Constraint Name | CheckConstraint |