PV_CO_CATEGORY

(SQL Table)

# PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description

1 PROCESS_INSTANCE Number(10,0) DECIMAL(10) NOT NULL Process Instance

2 PV_CO_CATEGORY_ID Character(64) VARCHAR2(64) NOT NULL Cohera Category Id

3 PV_CO_CAT_NAME Character(128) VARCHAR2(128) NOT NULL Cohera Category Name

4 PV_CO_CAT_PARENT Character(64) VARCHAR2(64) NOT NULL Cohera Category Parent

5 PV_CO_CAT_NAME_PAR Character(128) VARCHAR2(128) NOT NULL Cohera Parent Category Name

6 ACCOUNT Character(10) VARCHAR2(10) NOT NULL Account

7 ACCOUNT_2 Character(10) VARCHAR2(10) NOT NULL Account

#	PeopleSoft Field Name	PeopleSoft Field Type	Database Column Type	Description
1	PROCESS_INSTANCE	Number(10,0)	DECIMAL(10) NOT NULL	Process Instance
2	PV_CO_CATEGORY_ID	Character(64)	VARCHAR2(64) NOT NULL	Cohera Category Id
3	PV_CO_CAT_NAME	Character(128)	VARCHAR2(128) NOT NULL	Cohera Category Name
4	PV_CO_CAT_PARENT	Character(64)	VARCHAR2(64) NOT NULL	Cohera Category Parent
5	PV_CO_CAT_NAME_PAR	Character(128)	VARCHAR2(128) NOT NULL	Cohera Parent Category Name
6	ACCOUNT	Character(10)	VARCHAR2(10) NOT NULL	Account
7	ACCOUNT_2	Character(10)	VARCHAR2(10) NOT NULL	Account