LI_RELATION_IDRECNAME1Prompt Table: RB_RECDEFN_VW
Y/N Table Edit
Default Value: N
Y/N Table Edit
Default Value: N
Prompt Table: RB_RECDEFN_VW
Y/N Table Edit
Default Value: N
Y/N Table Edit
Default Value: N
RB_RELATION_VW(SQL View) |
Index Back |
|---|---|
View for the Record RelationView for the Record Relation Description |
| SELECT DISTINCT A.LI_RELATION_ID ,A.RECORDNAME ,A.LI_IS_MANY ,A.LI_IS_REQUIRED ,B.RECORDNAME , B.LI_IS_MANY ,B.LI_IS_REQUIRED ,A.RECORDNAME %Concat '<->' %Concat B.RECORDNAME FROM PS_RB_RELATION A ,PS_RB_RELATION B WHERE A.LI_RELATION_ID = B.LI_RELATION_ID AND A.RECORDNAME < B.RECORDNAME |
| # | PeopleSoft Field Name | PeopleSoft Field Type | Database Column Type | Description |
|---|---|---|---|---|
| 1 | LI_RELATION_ID |
Character(31) | VARCHAR2(31) NOT NULL | relation identifier(pk) |
| 2 | RECNAME1 |
Character(15) | VARCHAR2(15) NOT NULL |
Record Name 1
Prompt Table: RB_RECDEFN_VW |
| 3 | LI_IS_MANY1 | Character(1) | VARCHAR2(1) NOT NULL |
one to many?
Y/N Table Edit Default Value: N |
| 4 | LI_IS_REQUIRED1 | Character(1) | VARCHAR2(1) NOT NULL |
zero to one or zero to many?
Y/N Table Edit Default Value: N |
| 5 | RECNAME2 | Character(15) | VARCHAR2(15) NOT NULL |
Record Name
Prompt Table: RB_RECDEFN_VW |
| 6 | LI_IS_MANY2 | Character(1) | VARCHAR2(1) NOT NULL |
one to many?
Y/N Table Edit Default Value: N |
| 7 | LI_IS_REQUIRED2 | Character(1) | VARCHAR2(1) NOT NULL |
zero to one or zero to many?
Y/N Table Edit Default Value: N |
| 8 | DESCR40 | Character(40) | VARCHAR2(40) NOT NULL | This is a description field that holds 40 characters. |