PC_CHC_CFG (SQL Table)	Index Back
Change Control Configuration Change Control Configuration

PC_CHC_CFG

(SQL Table)

Change Control Configuration

# PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description

1 PC_CHC_TEMPLATE Character(30) VARCHAR2(30) NOT NULL Change Control Template

2 PC_CHC_CFG_ACT Character(3) VARCHAR2(3) NOT NULL Add and Delete Activities
CRR=Change Request Required
CRR=Change Request Required
OFF=Off
ON=On
USR=User Input
Default Value: OFF

3 PC_CHC_CFG_ACT_DT Character(3) VARCHAR2(3) NOT NULL Updating Activity Dates
CRR=Change Request Required
CRR=Change Request Required
OFF=Off
ON=On
USR=User Input
Default Value: OFF

4 PC_CHC_CFG_ACT_MIL Character(3) VARCHAR2(3) NOT NULL Change Milestones
CRR=Change Request Required
CRR=Change Request Required
OFF=Off
ON=On
USR=User Input
Default Value: OFF

5 PC_CHC_CFG_ACT_ST Character(3) VARCHAR2(3) NOT NULL Updating Activity Status
CRR=Change Request Required
CRR=Change Request Required
OFF=Off
ON=On
USR=User Input
Default Value: OFF

6 PC_CHC_CFG_PRJ_DT Character(3) VARCHAR2(3) NOT NULL Updating Project Dates
CRR=Change Request Required
CRR=Change Request Required
OFF=Off
ON=On
USR=User Input
Default Value: OFF

7 PC_CHC_CFG_PRJ_ST Character(3) VARCHAR2(3) NOT NULL Updating Project Status
CRR=Change Request Required
CRR=Change Request Required
OFF=Off
ON=On
USR=User Input
Default Value: OFF

8 PC_CHC_CFG_RES Character(3) VARCHAR2(3) NOT NULL Add and Delete Resource
CRR=Change Request Required
CRR=Change Request Required
OFF=Off
ON=On
USR=User Input
Default Value: OFF

9 PC_CHC_CFG_RES_DT Character(3) VARCHAR2(3) NOT NULL Updating Resource Dates
CRR=Change Request Required
CRR=Change Request Required
OFF=Off
ON=On
USR=User Input
Default Value: OFF

10 PC_CHC_CFG_RES_ST Character(3) VARCHAR2(3) NOT NULL Updating Resource Status
CRR=Change Request Required
CRR=Change Request Required
OFF=Off
ON=On
USR=User Input
Default Value: OFF

11 PC_CHC_CFG_TXN Character(3) VARCHAR2(3) NOT NULL Add and Delete Transactions
OFF=Off
ON=On
Default Value: OFF

12 PC_CHC_FIN_BUD_PLN Character(3) VARCHAR2(3) NOT NULL Change control template for budget finalization
CRR=Change Request Required
CRR=Change Request Required
OFF=Off
ON=On
USR=User Input
Default Value: OFF

13 PC_CHC_ADDL_RES Character(3) VARCHAR2(3) NOT NULL change control template for adding or deleting activity resource
CRR=Change Request Required
CRR=Change Request Required
OFF=Off
ON=On
USR=User Input
Default Value: OFF

14 PC_CHC_UPD_RES_UNT Character(3) VARCHAR2(3) NOT NULL change control template for updating resource units
CRR=Change Request Required
CRR=Change Request Required
OFF=Off
ON=On
USR=User Input
Default Value: OFF

15 PC_CHC_UPD_ETC Character(3) VARCHAR2(3) NOT NULL change control template for a resource's estimate to complete for a given activity
CRR=Change Request Required
CRR=Change Request Required
OFF=Off
ON=On
Default Value: OFF

#	PeopleSoft Field Name	PeopleSoft Field Type	Database Column Type	Description
1	PC_CHC_TEMPLATE	Character(30)	VARCHAR2(30) NOT NULL	Change Control Template
2	PC_CHC_CFG_ACT	Character(3)	VARCHAR2(3) NOT NULL	Add and Delete Activities CRR=Change Request Required CRR=Change Request Required OFF=Off ON=On USR=User Input Default Value: OFF
3	PC_CHC_CFG_ACT_DT	Character(3)	VARCHAR2(3) NOT NULL	Updating Activity Dates CRR=Change Request Required CRR=Change Request Required OFF=Off ON=On USR=User Input Default Value: OFF
4	PC_CHC_CFG_ACT_MIL	Character(3)	VARCHAR2(3) NOT NULL	Change Milestones CRR=Change Request Required CRR=Change Request Required OFF=Off ON=On USR=User Input Default Value: OFF
5	PC_CHC_CFG_ACT_ST	Character(3)	VARCHAR2(3) NOT NULL	Updating Activity Status CRR=Change Request Required CRR=Change Request Required OFF=Off ON=On USR=User Input Default Value: OFF
6	PC_CHC_CFG_PRJ_DT	Character(3)	VARCHAR2(3) NOT NULL	Updating Project Dates CRR=Change Request Required CRR=Change Request Required OFF=Off ON=On USR=User Input Default Value: OFF
7	PC_CHC_CFG_PRJ_ST	Character(3)	VARCHAR2(3) NOT NULL	Updating Project Status CRR=Change Request Required CRR=Change Request Required OFF=Off ON=On USR=User Input Default Value: OFF
8	PC_CHC_CFG_RES	Character(3)	VARCHAR2(3) NOT NULL	Add and Delete Resource CRR=Change Request Required CRR=Change Request Required OFF=Off ON=On USR=User Input Default Value: OFF
9	PC_CHC_CFG_RES_DT	Character(3)	VARCHAR2(3) NOT NULL	Updating Resource Dates CRR=Change Request Required CRR=Change Request Required OFF=Off ON=On USR=User Input Default Value: OFF
10	PC_CHC_CFG_RES_ST	Character(3)	VARCHAR2(3) NOT NULL	Updating Resource Status CRR=Change Request Required CRR=Change Request Required OFF=Off ON=On USR=User Input Default Value: OFF
11	PC_CHC_CFG_TXN	Character(3)	VARCHAR2(3) NOT NULL	Add and Delete Transactions OFF=Off ON=On Default Value: OFF
12	PC_CHC_FIN_BUD_PLN	Character(3)	VARCHAR2(3) NOT NULL	Change control template for budget finalization CRR=Change Request Required CRR=Change Request Required OFF=Off ON=On USR=User Input Default Value: OFF
13	PC_CHC_ADDL_RES	Character(3)	VARCHAR2(3) NOT NULL	change control template for adding or deleting activity resource CRR=Change Request Required CRR=Change Request Required OFF=Off ON=On USR=User Input Default Value: OFF
14	PC_CHC_UPD_RES_UNT	Character(3)	VARCHAR2(3) NOT NULL	change control template for updating resource units CRR=Change Request Required CRR=Change Request Required OFF=Off ON=On USR=User Input Default Value: OFF
15	PC_CHC_UPD_ETC	Character(3)	VARCHAR2(3) NOT NULL	change control template for a resource's estimate to complete for a given activity CRR=Change Request Required CRR=Change Request Required OFF=Off ON=On Default Value: OFF