EODI_APT_USER (SQL Table)	Index Back
Appointment Users

EODI_APT_USER

(SQL Table)

Appointment Users

# PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description

1 EODI_APT_TRANS_ID Number(15,0) DECIMAL(15) NOT NULL Apt Transaction ID

2 OPRID Character(30) VARCHAR2(30) NOT NULL A user's ID (see PSOPRDEFN).
Prompt Table: PSOPRDEFN_SRCH

3 EMAILID Character(70) VARCHAR2(70) NOT NULL A user's E-mail address

4 EODI_LAST_REP_DTTM DateTime(26) TIMESTAMP Last Replication Date Time

#	PeopleSoft Field Name	PeopleSoft Field Type	Database Column Type	Description
1	EODI_APT_TRANS_ID	Number(15,0)	DECIMAL(15) NOT NULL	Apt Transaction ID
2	OPRID	Character(30)	VARCHAR2(30) NOT NULL	A user's ID (see PSOPRDEFN). Prompt Table: PSOPRDEFN_SRCH
3	EMAILID	Character(70)	VARCHAR2(70) NOT NULL	A user's E-mail address
4	EODI_LAST_REP_DTTM	DateTime(26)	TIMESTAMP	Last Replication Date Time