BC_PRJREQST_MST(SQL Table) |
Index Back |
---|---|
Project Request MilestonesStores 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. |