INTFC_ACT_TAO(SQL Table) |
Index Back |
|---|---|
Project Resource Interface |
| # | 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 |
| 4 | INTFC_TYPE | Character(3) | VARCHAR2(3) NOT NULL | Trans Load Type |
| 5 | INTFC_STATUS | Character(3) | VARCHAR2(3) NOT NULL |
Interface Status
CON=Consolidated DON=Mass Changes Generated ERR=Error NEW=Mass Changes Not Generated REP=Replaced by Other Records (AP) UNI=Unitized Default Value: NEW |
| 6 | LOAD_STATUS | Character(3) | VARCHAR2(3) NOT NULL |
/* -> JMZ. PSOFT. 11-OCT-2002 */
New Status were added : HLD and INP for Asset Management.
/* <- JMZ. PSOFT. 11-OCT-2002 */
CON=Consolidated DON=Loaded ERR=Errored EXC=Excluded HLD=On Hold INP=In Process NEW=Pending PGI=PO Grp Incomplete REP=Replaced UNI=Unitized Default Value: NEW |
| 7 | ORIG_INTFC_ID | Number(8,0) | INTEGER NOT NULL | Original Interface ID |
| 8 | ORIG_LINE_NUM | Number(8,0) | INTEGER NOT NULL | Original Interface Line Number |
| 9 | ACTIVITY_DESCR | Character(30) | VARCHAR2(30) NOT NULL | Activity Description |
| 10 | ACTIVITY_TYPE | Character(5) | VARCHAR2(5) NOT NULL |
Activity Type
A=Activity Type E=Entry Type G=Group Type/Origin O=Activity Type/Origin R=Entry Type/Reason Default Value: 00000 Prompt Table: PROJ_ACT_TBL |
| 11 | SYSTEM_SOURCE | Character(3) | VARCHAR2(3) NOT NULL |
Identifies the application or source system that generated a journal entry.
Release 8.80 - 11/14/2002 - RVlasic - Removed GDM (JrnlGen - Deduction Management) from Translate Values.
SUJ---Included a label as Product.
Release 8.9 - 05/11/2005 - RVlasic - Added PRV (Variance Pricing) and PKK (KK Budget Journal) and deleted GLK for Project Costing per Brian Cohen.
Default Value: BPC |
| 12 | PERCENT_COMPLETE | Number(6,2) | DECIMAL(5,2) NOT NULL | % Complete |
| 13 | EARLY_START_DT | Date(10) | DATE | Early Start Date |
| 14 | LATE_START_DT | Date(10) | DATE | Late Start Date |
| 15 | ACTUAL_START_DT | Date(10) | DATE | Actual Start Date |
| 16 | EARLY_FINISH_DT | Date(10) | DATE | Early Finish Date |
| 17 | LATE_FINISH_DT | Date(10) | DATE | Late Finish Date |
| 18 | ACTUAL_FINISH_DT | Date(10) | DATE | Actual Finish Date |
| 19 | BASELINE_FINISH_DT | Date(10) | DATE | Baseline Finish Date |
| 20 | BASELINE_START_DT | Date(10) | DATE | Baseline Start Date |
| 21 | BCWP | Number(3,0) | SMALLINT NOT NULL | BCWP - Worked Performed |
| 22 | BCWS | Number(3,0) | SMALLINT NOT NULL | BCWS Work Scheduled |
| 23 | ACT_TYPE_SCH | Character(5) | VARCHAR2(5) NOT NULL |
Schedule Activity Type
Prompt Table: PC_ACT_TYPE_SCH |
| 24 | DTTM_STAMP | DateTime(26) | TIMESTAMP | Specifies the date and time of the last update to an entry. This field is maintained by PeopleSoft and is used in a variety of contexts. |
| 25 | DRAWING_NAME | Character(8) | VARCHAR2(8) NOT NULL | Drawing Name |
| 26 | ACTIVITY_USER1 | Character(10) | VARCHAR2(10) NOT NULL | User 1 |
| 27 | ACTIVITY_USER2 | Character(10) | VARCHAR2(10) NOT NULL | User 2 |
| 28 | ACTIVITY_USER3 | Character(10) | VARCHAR2(10) NOT NULL | User 3 |
| 29 | ACTIVITY_USER4 | Character(10) | VARCHAR2(10) NOT NULL | User 4 |
| 30 | ACTIVITY_USER5 | Character(10) | VARCHAR2(10) NOT NULL | User 5 |
| 31 | PC_ACT_USER_DT1 | Date(10) | DATE | Date 1 |
| 32 | PC_ACT_USER_DT2 | Date(10) | DATE | Date 2 |
| 33 | PC_USER_CURRENCY | Character(3) | VARCHAR2(3) NOT NULL |
User Currency
Prompt Table: CURRENCY_CD_TBL |
| 34 | PC_ACT_USERAMT1 | Signed Number(17,2) | DECIMAL(15,2) NOT NULL | Amount 1 |
| 35 | PC_ACT_USERAMT2 | Signed Number(17,2) | DECIMAL(15,2) NOT NULL | Amount 2 |
| 36 | PC_ACT_USERAMT3 | Signed Number(17,2) | DECIMAL(15,2) NOT NULL | Amount 3 |
| 37 | SETID | Character(5) | VARCHAR2(5) NOT NULL |
SetID
Prompt Table: SETID_TBL |
| 38 | OPRID | Character(30) | VARCHAR2(30) NOT NULL | A user's ID (see PSOPRDEFN). |
| 39 | PROCESS_INSTANCE | Number(10,0) | DECIMAL(10) NOT NULL | Process Instance |
| 40 | DESCR254 | Character(254) | VARCHAR2(254) NOT NULL | Description of length 254 |
| 41 | ACT_LOC_EFFDT | Date(10) | DATE | Activity Location Effdt |
| 42 | EFFSEQ | Number(3,0) | SMALLINT NOT NULL |
Effective Sequence
Default Value: 1 |
| 43 | LOCATION | Character(10) | VARCHAR2(10) NOT NULL |
Location Code
Default Value: LOCATION_TBL.LOCATION Prompt Table: LOCATION_TBL |
| 44 | LOCATION_FRACTION | Number(4,2) | DECIMAL(3,2) NOT NULL |
Fraction of Cost at Location
Default Value: 1 |
| 45 | ACTIVITY_STATUS | Character(1) | VARCHAR2(1) NOT NULL |
Activity Status
Prompt Table: PROJ_STATUS_TBL |
| 46 | ACT_STATUS_EFFDT | Date(10) | DATE | Activity Status Effective Date |
| 47 | START_DT_2 | Date(10) | DATE | Start Date |
| 48 | END_DT_2 | Date(10) | DATE | End Date |
| 49 | START_DT | Date(10) | DATE | Start Date |
| 50 | END_DT | Date(10) | DATE | End Date |
| 51 | ACTIVITY_PRIORITY | Number(3,0) | SMALLINT NOT NULL | Activity Priority |
| 52 | ACT_PCT_COMPLETE | Number(6,2) | DECIMAL(5,2) NOT NULL | Percent Complete |
| 53 | QUALITY_DTTM | DateTime(26) | TIMESTAMP | Quality Date |
| 54 | QUALITY_TYPE | Character(3) | VARCHAR2(3) NOT NULL |
Quality Type
Prompt Table: PROJ_QUAL_TBL |
| 55 | QUALITY_RATING | Number(3,0) | SMALLINT NOT NULL | Quality Rating |
| 56 | QUALITY_WEIGHT | Number(3,0) | SMALLINT NOT NULL | Quality Weighting |
| 57 | QUALITY_MEMBER | Character(11) | VARCHAR2(11) NOT NULL |
Quality Team Member
Prompt Table: PROJ_TEAM_VW |
| 58 | COUNTRY | Character(3) | VARCHAR2(3) NOT NULL |
Country
Prompt Table: COUNTRY_TBL |
| 59 | ADDRESS1 | Character(55) | VARCHAR2(55) NOT NULL | Address 1 |
| 60 | ADDRESS2 | Character(55) | VARCHAR2(55) NOT NULL | Address 2 |
| 61 | ADDRESS3 | Character(55) | VARCHAR2(55) NOT NULL | Address 3 |
| 62 | ADDRESS4 | Character(55) | VARCHAR2(55) NOT NULL | Address 4 |
| 63 | CITY | Character(30) | VARCHAR2(30) NOT NULL | City |
| 64 | NUM1 | Character(6) | VARCHAR2(6) NOT NULL | Number 1 |
| 65 | NUM2 | Character(6) | VARCHAR2(6) NOT NULL | Number 2 |
| 66 | HOUSE_TYPE | Character(2) | VARCHAR2(2) NOT NULL |
House Type
AB=House Boat WW=Trailer |
| 67 | ADDR_FIELD1 | Character(2) | VARCHAR2(2) NOT NULL | Address Field 1 |
| 68 | ADDR_FIELD2 | Character(4) | VARCHAR2(4) NOT NULL | Address Field 2 |
| 69 | ADDR_FIELD3 | Character(4) | VARCHAR2(4) NOT NULL | Address Field 3 |
| 70 | COUNTY | Character(30) | VARCHAR2(30) NOT NULL | County |
| 71 | STATE | Character(6) | VARCHAR2(6) NOT NULL |
State
Prompt Table: %EDIT_STATE |
| 72 | POSTAL | Character(12) | VARCHAR2(12) NOT NULL | Postal |
| 73 | GEO_CODE | Character(11) | VARCHAR2(11) NOT NULL | Geo Code |
| 74 | IN_CITY_LIMIT | Character(1) | VARCHAR2(1) NOT NULL |
In City Limit
Y/N Table Edit |
| 75 | RATE_PLAN | Character(15) | VARCHAR2(15) NOT NULL |
Rate Plan - A Rate Plan will allow rate sets to be stacked on top of each other so that the output from one rate set can be used to create additional output from the next rate set. Rate Plans will replace existing Burden Plans in release 8.9. A Rate Plan could be tied to Project Type, Project, Activity or Contract line.
Prompt Table: PC_RATE_PLAN |
| 76 | PC_MILESTONE_FLG | Character(1) | VARCHAR2(1) NOT NULL |
Milestone Activity
N=No Y=Yes Y/N Table Edit |
| 77 | AFUDC_ACT_SW | Character(1) | VARCHAR2(1) NOT NULL |
Allow AFUDC Calculation
Y/N Table Edit |
| 78 | ACT_TEMPLATE_SW | Character(1) | VARCHAR2(1) NOT NULL | Use Activity as Template |
| 79 | PC_SCH_FIELD1 | Character(40) | VARCHAR2(40) NOT NULL | Generic field used for Projects Third Party Schedule Integration. |
| 80 | PC_SCH_FIELD2 | Character(40) | VARCHAR2(40) NOT NULL | Generic field used for Projects Third Party Schedule Integration. |
| 81 | PC_SCH_FIELD3 | Character(40) | VARCHAR2(40) NOT NULL | Generic field used for Projects Third Party Schedule Integration. |
| 82 | PC_SCH_FIELD4 | Character(40) | VARCHAR2(40) NOT NULL | Generic field used for Projects Third Party Schedule Integration. |
| 83 | PC_SCH_FIELD5 | Character(40) | VARCHAR2(40) NOT NULL | Generic field used for Projects Third Party Schedule Integration. |
| 84 | PC_SCH_FIELD6 | Character(40) | VARCHAR2(40) NOT NULL | Generic field used for Projects Third Party Schedule Integration. |
| 85 | PC_SCH_FIELD7 | Character(40) | VARCHAR2(40) NOT NULL | Generic field used for Projects Third Party Schedule Integration. |
| 86 | SUMMARY_ACT | Character(1) | VARCHAR2(1) NOT NULL |
Flag to indicate whether an activity is summary or detail.
N=Detail Activity Y=Summary Activity |
| 87 | PC_DURATION | Number(11,2) | DECIMAL(10,2) NOT NULL | Duration |
| 88 | ENFORCE | Character(1) | VARCHAR2(1) NOT NULL |
Enforce project team based prompt. Besides the defined translate values, this field is updated with a value of 'N' when team is not enforced in any of the products.
E=Expenses N=No T=Time&Labor Y=Exp and TL |
| 89 | PC_CHC_ACT_SW | Character(1) | VARCHAR2(1) NOT NULL | Enable Change Control |
| 90 | PGM_SCHED_METHOD | Character(1) | VARCHAR2(1) NOT NULL |
The method to be used for Project Scheduling. Valid methods are: Fixed Units, Fixed Duration, and Fixed Work
D=Fixed Duration U=Fixed Units W=Fixed Work |
| 91 | FMS_DTTM_STAMP | DateTime(26) | TIMESTAMP | Specifies the date and time of the original entry. |
| 92 | FMS_OPRID | Character(30) | VARCHAR2(30) NOT NULL | Specifies the User ID which made the original entry. |
| 93 | FMS_LASTUPDDTTM | DateTime(26) | TIMESTAMP | Specifies the date and time of the last update to an entry. |
| 94 | FMS_LASTUPDOPRID | Character(30) | VARCHAR2(30) NOT NULL | Specifies the User ID which made the last update to an entry. |
| 95 | PC_CHC_COUNT | Number(15,0) | DECIMAL(15) NOT NULL | Count of Changes |
| 96 | NEWVALUE | Character(65) | VARCHAR2(65) NOT NULL | New Value |
| 97 | WBS_ID | Character(100) | VARCHAR2(100) NOT NULL | WBS ID |
| 98 | LEVEL1 | Number(5,0) | INTEGER NOT NULL | Level 1 |
| 99 | LEVEL2 | Number(5,0) | INTEGER NOT NULL | Level 2 |
| 100 | LEVEL3 | Number(5,0) | INTEGER NOT NULL | Level 3 |
| 101 | LEVEL4 | Number(5,0) | INTEGER NOT NULL | Level 4 |
| 102 | LEVEL5 | Number(5,0) | INTEGER NOT NULL | Level 5 |
| 103 | LEVEL6 | Number(5,0) | INTEGER NOT NULL | Level 6 |
| 104 | LEVEL7 | Number(5,0) | INTEGER NOT NULL | Level 7 |
| 105 | LEVEL8 | Number(5,0) | INTEGER NOT NULL | Level 8 |
| 106 | LEVEL9 | Number(5,0) | INTEGER NOT NULL | Level 9 |
| 107 | LEVEL10 | Number(5,0) | INTEGER NOT NULL | Level 10 |
| 108 | LEVEL11 | Number(5,0) | INTEGER NOT NULL | Level 11 |
| 109 | LEVEL12 | Number(5,0) | INTEGER NOT NULL | Level 12 |
| 110 | LEVEL13 | Number(5,0) | INTEGER NOT NULL | Level 13 |
| 111 | LEVEL14 | Number(5,0) | INTEGER NOT NULL | Level 14 |
| 112 | LEVEL15 | Number(5,0) | INTEGER NOT NULL | Level 15 |
| 113 | LEVEL16 | Number(5,0) | INTEGER NOT NULL | Level 16 |
| 114 | LEVEL17 | Number(5,0) | INTEGER NOT NULL | Level 17 |
| 115 | LEVEL18 | Number(5,0) | INTEGER NOT NULL | Level 18 |
| 116 | LEVEL19 | Number(5,0) | INTEGER NOT NULL | Level 19 |
| 117 | LEVEL20 | Number(5,0) | INTEGER NOT NULL | Level 20 |
| 118 | LEVEL21 | Number(5,0) | INTEGER NOT NULL | Level 21 |
| 119 | LEVEL22 | Number(5,0) | INTEGER NOT NULL | Level 22 |
| 120 | LEVEL23 | Number(5,0) | INTEGER NOT NULL | Level 23 |
| 121 | LEVEL24 | Number(5,0) | INTEGER NOT NULL | Level 24 |
| 122 | LEVEL25 | Number(5,0) | INTEGER NOT NULL | Level 25 |
| 123 | LEVEL26 | Number(5,0) | INTEGER NOT NULL | Level 26 |
| 124 | LEVEL_NUM | Number(3,0) | SMALLINT NOT NULL | Level |
| 125 | ROW_NUMBER_5 | Number(5,0) | INTEGER NOT NULL | Row Number |
| 126 | DEADLINE_DT | Date(10) | DATE | Deadline Date |
| 127 | CONSTRAINT_DT | Date(10) | DATE | Constraint Date |
| 128 | CONSTRAINT_TYPE | Character(4) | VARCHAR2(4) NOT NULL |
Constraint Type
ALAP=As Late As Possible ASAP=As Soon As Possible ENET=End No Earlier Than ENLT=End No Later Than MEO=Must End On MSO=Must Start On SNET=Start No Earlier Than SNLT=Start No Later Than |
| 129 | PC_ACT_OWNER | Character(11) | VARCHAR2(11) NOT NULL | Activity Owner - The employee id of the individual who is responsible for the execution of an activity or a group of activities. |
| 130 | CURRENCY_CD | Character(3) | VARCHAR2(3) NOT NULL | Currency Code |
| 131 | EXISTING_ACT | Character(1) | VARCHAR2(1) NOT NULL | Field to identify whether an activity is an existing activity or is new. |
| 132 | COSTING_ACT_SW | Character(1) | VARCHAR2(1) NOT NULL | Activity Costing Switch - determines whether an activity is available for charging. 'Y' = charging is allowed; 'N' = charging is not allowed. |
| 133 | PC_ACT_DEF_CALC_MT | Character(1) | VARCHAR2(1) NOT NULL |
Activity Calculation Method
D=Duration E=End Date S=Start Date |
| 134 | PARTICIPATING | Character(1) | VARCHAR2(1) NOT NULL |
Participating
Y/N Table Edit Default Value: Y |
| 135 | P6_WBS_FLAG | Character(1) | VARCHAR2(1) NOT NULL |
A flag, when set to Y(es) indicates that an activity originated from a Primavera WBS.
N=Activity Y=Work Breakdown Structure |
| 136 | UPDATE_PCT_COMP | Character(1) | VARCHAR2(1) NOT NULL |
Indicator to specify whether the activity percent complete should be updated from the Third Party Loader.
N=No Y=Yes Y/N Table Edit Default Value: Y |
| 137 | PROJECT_OBJECTID | Number(10,0) | DECIMAL(10) NOT NULL | A unique ID that is the Project key to a corresponding table in an external system such as Primavera. |
| 138 | ACTIVITY_OBJECTID | Number(10,0) | DECIMAL(10) NOT NULL | A unique ID that is the Activity key to a corresponding table in an external system such as Primavera. |
| 139 | P6_ACTIVITY_GUID | Character(36) | VARCHAR2(36) NOT NULL | P6 ACTIVITY GUID |