| # |
PeopleSoft Field Name |
PeopleSoft Field Type |
Database Column Type |
Description |
| 1 |
 BUSINESS_UNIT |
Character(5) |
VARCHAR2(5) NOT NULL |
Business Unit
|
| 2 |
PROJECT_ID |
Character(15) |
VARCHAR2(15) NOT NULL |
Project Id ChartField
|
| 3 |
PC_CHC_COUNT |
Number(15,0) |
DECIMAL(15) NOT NULL |
Count of Changes
|
| 4 |
CHANGE_REQ_ID |
Character(15) |
VARCHAR2(15) NOT NULL |
Change Request ID
|
| 5 |
ACTIVITY_ID |
Character(15) |
VARCHAR2(15) NOT NULL |
Activity ID
|
| 6 |
EMPLID |
Character(11) |
VARCHAR2(11) NOT NULL |
Employee ID
|
| 7 |
PC_CHC_OPRID |
Character(50) |
VARCHAR2(50) NOT NULL |
Username
|
| 8 |
PC_CHC_INFO_DESCR |
Character(3) |
VARCHAR2(3) NOT NULL |
Description of Change
ADD=Activity Add
ADE=Activity End Date
ADL=Activity Delete
ADS=Activity Start Date
AMS=Activity Milestone Change
ARA=Activity Resource Add
ARD=Activity Resource Delete
AST=Activity Status
BUD=Finalize Budget
ETC=Updating ETC
PDE=Project End Date
PDS=Project Start Date
PST=Project Status
RAD=Resource Add
RDE=Resource End Date
RDL=Resource Delete
RDS=Resource Start Date
RST=Resource Status
RUE=Resource Unit Change
TAD=Transaction Add
TDE=Transaction Date End
TDL=Transaction Delete
TDS=Transaction Date Start
TST=Transaction Status
|
| 9 |
DATETIME_STAMP |
DateTime(26) |
TIMESTAMP |
DateTime Stamp
|
| 10 |
NEWVALUE |
Character(65) |
VARCHAR2(65) NOT NULL |
New Value
|
| 11 |
OLDVALUE |
Character(65) |
VARCHAR2(65) NOT NULL |
Old Value
|
| 12 |
PC_CHC_INFO_TYPE |
Character(3) |
VARCHAR2(3) NOT NULL |
Type Of Change
EST=Estimate Increase
OTH=Other
RES=Resource Swap
SCH=Schedule
SCO=Scope Change
|
| 13 |
PC_CHC_INFO_REASON |
Character(254) |
VARCHAR2(254) NOT NULL |
Justification for Change
|
| 14 |
DESCR254 |
Character(254) |
VARCHAR2(254) NOT NULL |
Description of length 254
|
| 15 |
DESCRLONG |
Long Character |
CLOB |
Long Description
|
| 16 |
PC_CHC_INPUT_FLG |
Character(3) |
VARCHAR2(3) NOT NULL |
Change Control Input Flag
|
| 17 |
FMS_DTTM_STAMP |
DateTime(26) |
TIMESTAMP |
Specifies the date and time of the original entry.
|
| 18 |
FMS_OPRID |
Character(30) |
VARCHAR2(30) NOT NULL |
Specifies the User ID which made the original entry.
|
| 19 |
FMS_LASTUPDDTTM |
DateTime(26) |
TIMESTAMP |
Specifies the date and time of the last update to an entry.
|
| 20 |
FMS_LASTUPDOPRID |
Character(30) |
VARCHAR2(30) NOT NULL |
Specifies the User ID which made the last update to an entry.
|