PSOPA_ENTITY (SQL Table)	Index Back
OPA Datamodel Entity mapping OPA Datamodel Entity mapping

PSOPA_ENTITY

(SQL Table)

OPA Datamodel Entity mapping

Related Language Record: PSOPA_ENT_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_RECDEF_VW

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

5 OPA_ENTITY_TYPE Character(3) VARCHAR2(3) NOT NULL Entity Type
GI=Global Input
GO=Global Output
IN=Input
IO=Input/Output
OUT=Output

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

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_RECDEF_VW
4	OPA_SEQ_NBR	Number(3,0)	SMALLINT NOT NULL	Sequence Number
5	OPA_ENTITY_TYPE	Character(3)	VARCHAR2(3) NOT NULL	Entity Type GI=Global Input GO=Global Output IN=Input IO=Input/Output OUT=Output
6	DESCR254	Character(254)	VARCHAR2(254) NOT NULL	Description of length 254
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.