BUSINESS_UNITPROJECT_IDACTIVITY_IDPrompt Table: PROJ_ACTIVITY
SEQNORS_TRNSMSG_TMP(SQL Table) |
Index Back |
|---|---|
Transfer Update Confim MsgTemp table for Transfer Assignments update confirmation messages. If PGM is not installed, or if there is only project and no project activity, then just ignore the activity_id. |
| # | 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 | ACTIVITY_ID |
Character(15) | VARCHAR2(15) NOT NULL |
Activity ID
Prompt Table: PROJ_ACTIVITY |
| 4 | SEQNO |
Number(5,0) | INTEGER NOT NULL | Sequence Number |
| 5 | DESCR254 | Character(254) | VARCHAR2(254) NOT NULL | Description of length 254 |
| 6 | DATE_IN_EFFECT | Date(10) | DATE | 01/27/2000 RML Added "As of date" label 03/23/2004 SFC Added PRICE_LIST_DATE label 06/04/2004 SFC Added PRODUCT_PRICE_DAT label |
| 7 | COMMENTS_254 | Character(254) | VARCHAR2(254) NOT NULL | EDI Comments |