PSOPA_ENT_REL (SQL Table)	Index Back
Entity Relationship

PSOPA_ENT_REL

(SQL Table)

Entity Relationship

Related Language Record: PSOPA_REL_LANG

# PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description

1 OPA_DATAMODEL_ID Character(40) VARCHAR2(40) NOT NULL Data Model ID

2 OPA_ENTITY_NAME Character(50) VARCHAR2(50) NOT NULL Entity Name

3 RECNAME Character(15) VARCHAR2(15) NOT NULL Record (Table) Name (see PSRECDEFN).
Prompt Table: OPA_ENTREC_VW

4 OPA_DSTENTITY_NAME Character(50) VARCHAR2(50) NOT NULL Target Entity
Prompt Table: OPA_DMENT_VW

5 OPA_SEQ_NBR Number(3,0) SMALLINT NOT NULL Sequence Number

6 OPA_ENTREL_NAME Character(50) VARCHAR2(50) NOT NULL Relationship Name

7 OPA_ENT_REL_TYPE Character(3) VARCHAR2(3) NOT NULL Entity Relationship Type
11=One To One
1M=One To Many
M1=Many To One
MM=Many To Many

8 DESCR254 Character(254) VARCHAR2(254) NOT NULL Description of length 254

9 OPA_USER_DEFINED Character(1) VARCHAR2(1) NOT NULL User Defined
N=No
Y=Yes
Default Value: Y

10 LAST_UPDATE_DTTM DateTime(26) TIMESTAMP Specifies the date and time of the last update to an entry. This field is maintained by PeopleSoft and is used in a variety of contexts.

#	PeopleSoft Field Name	PeopleSoft Field Type	Database Column Type	Description
1	OPA_DATAMODEL_ID	Character(40)	VARCHAR2(40) NOT NULL	Data Model ID
2	OPA_ENTITY_NAME	Character(50)	VARCHAR2(50) NOT NULL	Entity Name
3	RECNAME	Character(15)	VARCHAR2(15) NOT NULL	Record (Table) Name (see PSRECDEFN). Prompt Table: OPA_ENTREC_VW
4	OPA_DSTENTITY_NAME	Character(50)	VARCHAR2(50) NOT NULL	Target Entity Prompt Table: OPA_DMENT_VW
5	OPA_SEQ_NBR	Number(3,0)	SMALLINT NOT NULL	Sequence Number
6	OPA_ENTREL_NAME	Character(50)	VARCHAR2(50) NOT NULL	Relationship Name
7	OPA_ENT_REL_TYPE	Character(3)	VARCHAR2(3) NOT NULL	Entity Relationship Type 11=One To One 1M=One To Many M1=Many To One MM=Many To Many
8	DESCR254	Character(254)	VARCHAR2(254) NOT NULL	Description of length 254
9	OPA_USER_DEFINED	Character(1)	VARCHAR2(1) NOT NULL	User Defined N=No Y=Yes Default Value: Y
10	LAST_UPDATE_DTTM	DateTime(26)	TIMESTAMP	Specifies the date and time of the last update to an entry. This field is maintained by PeopleSoft and is used in a variety of contexts.