PSOPA_DATAMODEL (SQL Table)	Index Back
Data Model Record Data Model Record

PSOPA_DATAMODEL

(SQL Table)

Data Model Record

Related Language Record: PSOPA_DAT_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 DESCR100 Character(100) VARCHAR2(100) NOT NULL Length 100 Description

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

4 CREATED_DTTM DateTime(26) TIMESTAMP Created Datetime

5 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	DESCR100	Character(100)	VARCHAR2(100) NOT NULL	Length 100 Description
3	OPA_USER_DEFINED	Character(1)	VARCHAR2(1) NOT NULL	User Defined N=No Y=Yes Default Value: Y
4	CREATED_DTTM	DateTime(26)	TIMESTAMP	Created Datetime
5	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.