CA_OPRID_CONTR (SQL Table)	Index Back
My Contracts List of my contracts

CA_OPRID_CONTR

(SQL Table)

My Contracts

List of my contracts

# PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description

1 OPRID Character(30) VARCHAR2(30) NOT NULL A user's ID (see PSOPRDEFN).

2 CONTRACT_NUM Character(25) VARCHAR2(25) NOT NULL Contract
Prompt Table: CA_CONTR_HDR

3 FAVORITE Character(1) VARCHAR2(1) NOT NULL To be used on my contracts
Y/N Table Edit
Default Value: N

4 MANUAL_ADD Character(1) VARCHAR2(1) NOT NULL Indicator on my contracts if the contract is added manually using Adjust My Contracts List page
Y/N Table Edit
Default Value: Y

5 LASTUPDDTTM 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.

6 LASTUPDOPRID Character(30) VARCHAR2(30) NOT NULL Specifies the User ID which made 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	OPRID	Character(30)	VARCHAR2(30) NOT NULL	A user's ID (see PSOPRDEFN).
2	CONTRACT_NUM	Character(25)	VARCHAR2(25) NOT NULL	Contract Prompt Table: CA_CONTR_HDR
3	FAVORITE	Character(1)	VARCHAR2(1) NOT NULL	To be used on my contracts Y/N Table Edit Default Value: N
4	MANUAL_ADD	Character(1)	VARCHAR2(1) NOT NULL	Indicator on my contracts if the contract is added manually using Adjust My Contracts List page Y/N Table Edit Default Value: Y
5	LASTUPDDTTM	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.
6	LASTUPDOPRID	Character(30)	VARCHAR2(30) NOT NULL	Specifies the User ID which made the last update to an entry. This field is maintained by PeopleSoft and is used in a variety of contexts.