PC_MSP2_FILES

#	PeopleSoft Field Name	PeopleSoft Field Type	Database Column Type	Description
1	BUSINESS_UNIT	Character(5)	VARCHAR2(5) NOT NULL	Business Unit Default Value: OPR_DEF_TBL_PC.BUSINESS_UNIT Prompt Table: SP_BU_PC_NONVW
2	PROJECT_ID	Character(15)	VARCHAR2(15) NOT NULL	Project Id ChartField Prompt Table: SP_PROJ_NONVW
3	SEQNO	Number(5,0)	INTEGER NOT NULL	Sequence Number
4	ATTACHUSERFILE	Character(64)	VARCHAR2(64) NOT NULL	Attached File
5	ATTACHSYSFILENAME	Character(128)	VARCHAR2(128) NOT NULL	Unique Sys Filename
6	USERID	Character(30)	VARCHAR2(30) NOT NULL	A user's ID
7	PRIVATE_FLG	Character(1)	VARCHAR2(1) NOT NULL	Private N=No Y=Yes
8	PC_MSP2_LOCKED	Character(1)	VARCHAR2(1) NOT NULL	Locked File Y/N Table Edit Default Value: N
9	DESCR	Character(30)	VARCHAR2(30) NOT NULL	Description
10	OPRID_ENTERED_BY	Character(30)	VARCHAR2(30) NOT NULL	Entered By 07/25/2011 MRAD 12383033 :Ensured that OPRID_ENTERED_BY is set with format type of MixedCase. 03/22/2013 GL 16482301: Switched OPRID_ENTERED_BY back to MixedCase again. Please don't change it to UpperCase!!! FYI - The alternatives to use a User ID as uppercase: 1) Create your own User ID, add comments in the Field Properties, and fill out the Owner ID 2) Use %Upper meta-SQL in SQL statements 3) Use Upper function in peoplecodes Prompt Table: PSOPRDEFN_SRCH
11	DTTM_CREATED	DateTime(26)	TIMESTAMP NOT NULL	Datetime Created Default Value: %datetime