BC_PRJREQST_MST

(SQL Table)
Index Back

Project Request Milestones

Stores information relating to project milestones

# 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 MILESTONE_ID Character(6) VARCHAR2(6) NOT NULL Milestone_ID identifies the milestones that can be referenced from multiple functional areas.
4 ACTION_COUNT Number(6,0) INTEGER NOT NULL Action Count
5 DESCR Character(30) VARCHAR2(30) NOT NULL Description
6 MILESTONE_STATUS Character(2) VARCHAR2(2) NOT NULL Milestone Status
C=Completed
P=Pending
R=Ready
X=Cancelled
7 DUE_DATE Date(10) DATE Delivery Due Date from PO
8 ACTION_TYPE Character(1) VARCHAR2(1) NOT NULL Broadcast
D=log Deletedsequence number
E=Check doc seq enable option
G=Generate sequence number
R=Reset for 1099C Submission
X=Deleted from 1099C Prep Table
9 OWNER_ID Character(5) VARCHAR2(5) NOT NULL Owner ID
10 PPK_OWNER_ID Character(50) VARCHAR2(50) NOT NULL Operator ID for the approver

Prompt Table: PPK_OWNER_ID_VW

11 COMPLETED Character(1) VARCHAR2(1) NOT NULL Completed

Y/N Table Edit

12 COMPLETION_DATE Date(10) DATE Completion Date
13 COMPLETED_ID Character(11) VARCHAR2(11) NOT NULL Completed ID
14 REQUIRED_FLAG Character(1) VARCHAR2(1) NOT NULL Required Flag
N=No
Y=Yes
15 COMMENTS_254 Character(254) VARCHAR2(254) NOT NULL EDI Comments
16 FMS_DTTM_STAMP DateTime(26) TIMESTAMP Specifies the date and time of the original entry.
17 FMS_OPRID Character(30) VARCHAR2(30) NOT NULL Specifies the User ID which made the original entry.
18 FMS_LASTUPDDTTM DateTime(26) TIMESTAMP Specifies the date and time of the last update to an entry.
19 FMS_LASTUPDOPRID Character(30) VARCHAR2(30) NOT NULL Specifies the User ID which made the last update to an entry.