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 | Character(5) | VARCHAR2(5) NOT NULL | Business Unit | |
| 2 | Character(15) | VARCHAR2(15) NOT NULL | Project Id ChartField | |
| 3 | 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. |