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