PSOPA_ENTRELATR (SQL Table)	Index Back
Entity Relationship Attributes

PSOPA_ENTRELATR

(SQL Table)

Entity Relationship Attributes

# 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_TGT_ATTRNAME Character(36) VARCHAR2(36) NOT NULL Target Attribute
Prompt Table: OPA_ENTATTR_VW

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

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

8 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_TGT_ATTRNAME	Character(36)	VARCHAR2(36) NOT NULL	Target Attribute Prompt Table: OPA_ENTATTR_VW
6	OPA_SEQ_NBR	Number(3,0)	SMALLINT NOT NULL	Sequence Number
7	OPA_USER_DEFINED	Character(1)	VARCHAR2(1) NOT NULL	User Defined N=No Y=Yes Default Value: Y
8	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.