PC_ACT_DOCUMENT

(SQL Table)
Index Back

Project Documents

Project Documents

# PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description
1 BUSINESS_UNIT Character(5) VARCHAR2(5) NOT NULL Business Unit

Default Value: PROJECT.BUSINESS_UNIT

2 PROJECT_ID Character(15) VARCHAR2(15) NOT NULL Project Id ChartField

Prompt Table: PROJECT

3 ACTIVITY_ID Character(15) VARCHAR2(15) NOT NULL Activity ID
4 DOCUMENT_REQUESTS Number(7,0) INTEGER NOT NULL Number of Requests

Default Value: 1

5 DESCR254 Character(254) VARCHAR2(254) NOT NULL Description of length 254
6 ATTACHSYSFILENAME Character(128) VARCHAR2(128) NOT NULL Unique Sys Filename
7 ATTACHUSERFILE Character(64) VARCHAR2(64) NOT NULL Attached File