HCMD_OREL_TBL(SQL Table) |
Index Back |
|---|---|
Object relationship defs |
| # | PeopleSoft Field Name | PeopleSoft Field Type | Database Column Type | Description |
|---|---|---|---|---|
| 1 |  HCMD_CLASSID |
Character(12) | VARCHAR2(12) NOT NULL | EI_CLASSID |
| 2 | HCMD_RELATIONID |
Character(30) | VARCHAR2(30) NOT NULL | Created by Eric Solberg 2/18/02 Name of relationship for object descriptors |
| 3 | ACTIVE_FLAG | Character(1) | VARCHAR2(1) NOT NULL |
Active Flag
A=Active I=Inactive Default Value: A |
| 4 | DESCR | Character(30) | VARCHAR2(30) NOT NULL | Description |
| 5 | HCMD_RELATIONTYPE | Character(4) | VARCHAR2(4) NOT NULL |
Relationship Type
1:1=One-to-One 1:N=One-to-Many 1:N*=One-to-Many (Child) N:1=Many-to-One N:N=Many-to-Many |
| 6 | HCMD_CARDNTY_SRC | Character(2) | VARCHAR2(2) NOT NULL |
Source Cardinality
01=0..1 0N=0..n 11=1..1 1N=1..n |
| 7 | HCMD_CARDNTY_TGT | Character(2) | VARCHAR2(2) NOT NULL |
Target Cardinality
01=0..1 0N=0..n 11=1..1 1N=1..n |
| 8 | HCMD_TGT_CLASSID | Character(30) | VARCHAR2(30) NOT NULL |
Relationship Target
Prompt Table: HCMD_DANDB_PVW |
| 9 | HCMD_RELTRAVERSE | Character(1) | VARCHAR2(1) NOT NULL |
Relationship is traversable?
Y/N Table Edit Default Value: Y |
| 10 | HCMD_RELBIDIR | Character(1) | VARCHAR2(1) NOT NULL |
Relationship is Bidirectional?
Y/N Table Edit Default Value: Y |
| 11 | HCMD_USEINQUERIES | Character(1) | VARCHAR2(1) NOT NULL |
Use in Queries?
Y/N Table Edit Default Value: Y |
| 12 | HCMD_USEINRULES | Character(1) | VARCHAR2(1) NOT NULL |
Use in Rules?
Y/N Table Edit Default Value: Y |
| 13 | HCMD_USEINUI | Character(1) | VARCHAR2(1) NOT NULL |
Use in UI?
Y/N Table Edit Default Value: Y |
| 14 | HCMD_BYPASSINDIR | Character(1) | VARCHAR2(1) NOT NULL |
Bypass Indirection
Y/N Table Edit Default Value: N |
| 15 | DESCRLONG | Long Character | CLOB | Long Description |