Projects Interface Staging Table Structure

This table lists the details of the Projects Interface staging table structure:

Field Number	Field Name	Type	Criteria	Description
1	INTFC_ID	Number	Required	Batch interface identifier.
2	INTFC_LINE_NUM	Number	Required	Unique batch line identifier.
3	BUSINESS_UNIT	Character	Required	Prompts from the SP_BU_PC_NONVW table.
4	PROJECT_ID	Character	Required	Unique project identifier.
5	INTFC_TYPE	Character	Optional	Not used in the PeopleSoft Project Costing interface.
6	SYSTEM_SOURCE	Character	Optional	Populated in the Application Engine with BPC (batch processed) if not provided in the source file.
7	APPROVAL_SW	Character	Optional	Not used in the PeopleSoft Project Costing interface.
8	INTFC_STATUS	Character	Optional	Populated in the Application Engine with NEW if not provided in the source file.
9	LOAD_STATUS	Character	Optional	Populated in the Application Engine with NEW if not provided in the source file.
10	ORIG_INTFC_ID	Number	Optional	Not used in the PeopleSoft Project Costing interface.
11	ORIG_LINE_NUM	Number	Optional	Not used in the PeopleSoft Project Costing interface.
12	INTEGRATION_TMPL	Character	Required	Must be a value from the Integration Template table (PC_INT_TMPL). Default value is INTEGRATION_TMPL.OPR_DEF_TBL_PC if not provided in the source file.
13	DESCR	Character	Required	Project description up to 30 characters.
14	PROJECT_TYPE	Character	Optional	Prompts from the PROJ_TYPE_TBL table. Note: The default value of the rate set or rate plan is based on the project type if you associate a predefined rate set or rate plan with the project type and include the project type in the source file.
15	BUSINESS_UNIT_AM	Character	Optional	Not used in the PeopleSoft Project Costing interface.
16	ASSET_ID	Character	Optional	Not used in the PeopleSoft Project Costing interface.
17	PROFILE_ID	Character	Optional	Not used in the PeopleSoft Project Costing interface.
18	GROUP_ASSET_ID	Character	Optional	Not used in the PeopleSoft Project Costing interface.
19	PARENT_ID	Character	Optional	Not used in the PeopleSoft Project Costing interface.
20	AM_DISTRIB_STATUS	Character	Optional	Not used in the PeopleSoft Project Costing interface.
21	QUANTITY	Sign	Optional	Not used in the PeopleSoft Project Costing interface.
22	TAG_NUMBER	Character	Optional	Not used in the PeopleSoft Project Costing interface.
23	TRANS_CODE	Character	Optional	Not used in the PeopleSoft Project Costing interface.
24	TEMPLATE_ID	Character	Conditional	Not used in the PeopleSoft Project Costing interface.
25	TEMPLATE_SW	Character	Conditional	Not used in the PeopleSoft Project Costing interface.
26	AFUDC_PROJ_SW	Character	Conditional	Not used in the PeopleSoft Project Costing interface.
27	TARGET_PROJ_SW	Character	Optional	Not used in the PeopleSoft Project Costing interface.
28	SALES_TAX_PROJ_SW	Character	Optional	Not used in the PeopleSoft Project Costing interface.
29	DOCKET_NUMBER	Character	Optional	Not used in the PeopleSoft Project Costing interface.
30	PROJECT_FUNCTION	Character	Optional	Not used in the PeopleSoft Project Costing interface.
31	DTTM_STAMP	Date/Time	System-maintained	The date and time when the project is created.
32	OPRID	Character	Optional	The interface assigns an operator ID.
33	PROCESS_INSTANCE	Number	System-maintained	The interface assigns a process instance number.
34	DESCR254	Character	Optional	Project description up to 254 characters.
35	ADDRESS_ID	Character	Optional	Not used in the PeopleSoft Project Costing interface.
36	LOCATION_EFFDT	Date	Optional	Effective date of the project location. Populated with %Date (current server date) if not provided in the source file.
37	EFFSEQ	Number	Optional	Project location effective sequence or project status effective sequence. Default value is 1.
38	LOCATION	Character	Optional	Must be a value from the LOCATION_TBL table.
39	LOCATION_FRACTION	Number	Optional	Not used in the PeopleSoft Project Costing interface.
40	CUST_ID	Character	Optional	Not used in the PeopleSoft Project Costing interface.
41	PS_OWNER	Character	Optional	Not used in the PeopleSoft Project Costing interface.
42	FLEX_FORMULA	Character	Optional	Not used in the PeopleSoft Project Costing interface.
43	TEAM_MEMBER	Character	Optional	(Not used in the PeopleSoft Project Costing interface.)
44	PROJ_ROLE	Character	Optional	Project manager's project role. Prompts from the Project Role table (PROJ_ROLE).
45	EMAILID	Character	Optional	Project team member's email ID.
46	MANAGER_EFFDT	Date	Optional	MANAGER_EFFDT and MANAGER_START_DT must have the same date and must both be between the project start and end dates; otherwise, an error message appears. MANAGER_EFFDT, if left blank, is populated with the current date.
47	PROJECT_MANAGER	Character	Optional	If PROJECT_MANAGER is populated, PROJ_ROLE, MANAGER_START_DT, and MANAGER_END_DT are required to save the page; otherwise, an error message appears.
48	ROLE_TYPE	Character	Optional	Project team member's role type. If PROJECT_MANAGER is populated, this field is required to save the page.
49	MANAGER_START_DT	Date	Date	MANAGER_EFFDT and MANAGER_START_DT must have the same date and must both be between the project start and end dates; otherwise, an error message appears.
50	MANAGER_END_DT	Date	Date	If PROJECT_MANAGER is populated, this field is required to save the page.
51	STATUS_EFFDT	Date	Optional	Project's status effective date. Populated with %Date (current server date) if not provided in the source file.
52	PROJECT_STATUS	Character	Optional	Must be a value from the PROJ_STATUS_TBL table If a project status is provided in the source file, it must be previously defined against a processing status in the PROJ_STATUS_TBL table. If a project status is not provided, the default is based on the PC_STAT_DEFAULT table.
53	START_DT_2	Date	Optional	User-defined field.
54	END_DT_2	Date	Optional	User-defined field.
55	START_DT	Date	Optional	Project team member's start date.
56	END_DT	Date	Optional	Project team member's end date.
57	PROJECT_PRIORITY	Number	Optional	Project status priority.
58	PERCENT_COMPLETE	Number	Optional	Percent project is completed.
59	INTEREST_FACTOR	Sign	Optional	Interest calculation factor.
60	MILESTONE_EFFDT	Date	Optional	Not used in the PeopleSoft Project Costing interface.
61	MILESTONE_TYPE	Character	Optional	Not used in the PeopleSoft Project Costing interface.
62	MILESTONE_CODE	Character	Optional	Not used in the PeopleSoft Project Costing interface.
63	MILESTONE_ORIGIN	Character	Optional	Not used in the PeopleSoft Project Costing interface.
64	TRANS_DT	Date	Optional	Not used in the PeopleSoft Project Costing interface.
65	ACCOUNTING_DT	Date	Optional	Not used in the PeopleSoft Project Costing interface.
66	SCHEDULE_TYPE	Character	Optional	Prompts from the PROJ_PHASE_TBL table.
67	SCHEDULE_STATUS	Character	Optional	Populate the field with A (actual schedule) or E (estimated schedule). The default value is A.
68	SCHEDULE_DESCR	Character	Optional	Project phase description up to 30 characters.
69	FROM_DT	Date	Optional	Project phase begin date.
70	TO_DT	Date	Optional	Project phase end date.
71	DOCUMENT_TYPE	Character	Optional	Not used in the PeopleSoft Project Costing interface.
72	DOCUMENT_NAME	Character	Optional	Not used in the PeopleSoft Project Costing interface.
73	DOCUMENT_PATH	Character	Optional	Not used in the PeopleSoft Project Costing interface.
74	PROJECT_USER1	Character	Optional	User-defined field.
75	PROJECT_USER2	Character	Optional	User-defined field.
76	PROJECT_USER3	Character	Optional	User-defined field.
77	PROJECT_USER4	Character	Optional	User-defined field.
78	PROJECT_USER5	Character	Optional	User-defined field.
79	PROJECT_USER_DT6	Date	Optional	User-defined field.
80	PROJECT_USER_DT2	Date	Optional	User-defined field.
81	PC_USER_CURRENCY	Character	Optional	User-defined field. Prompts from the CURRENCY_CD_TBL table.
82	PROJECT_USERAMT1	Sign	Optional	User-defined field.
83	PROJECT_USERAMT2	Sign	Optional	User-defined field.
84	PROJECT_USERAMT1	Sign	Optional	User-defined field.
85	AN_GRP_ACTV_BUD	Character	Optional	Default value is INSTALLATION_PC.AN_GRP_ACTV_BUD. Prompts from the PROJ_AN_GRP_TBL.
86	AN_GRP_TOT_COSTS	Character	Optional	Default value is INSTALLATION_PC.AN_GRP_TOT_COSTS. Prompts from the PROJ_AN_GRP_TBL table.
87	SET_OVERRIDE	Character	Required under certain circumstances	Populated from the SP_SETID_NONVW table. General ledger uses this SetID for prompting and the Journal Edit process. The field is required if PeopleSoft General Ledger is installed or you use Projects Budgeting.
88	PROJ_TOLERANCE_TYP	Character	Optional	Not used in the PeopleSoft Project Costing interface.
89	PROJ_TOLERANCE_AMT	Number	Optional	Not used in the PeopleSoft Project Costing interface.
90	PROJ_TOLERANCE_PCT	Number	Optional	Not used in the current product release.
91	ADDRESS_SBR	Subrecord	Optional	The interface assigns address information.
1 (ADDRESS_SBR)	COUNTRY	Character	Optional	Country. Prompts from the COUNTRY_TBL table.
2 (ADDRESS_SBR)	ADDRESS1	Character	Optional	Address line 1.
3 (ADDRESS_SBR)	ADDRESS2	Character	Optional	Address line 2.
4 (ADDRESS_SBR)	ADDRESS3	Character	Optional	Address line 3.
5 (ADDRESS_SBR)	ADDRESS4	Character	Optional	Address line 4.
6 (ADDRESS_SBR)	CITY	Character	Optional	City.
7 (ADDRESS_SBR)	NUM1	Character	Optional	Number 1.
8 (ADDRESS_SBR)	NUM2	Character	Optional	Number 2.
9 (ADDRESS_SBR)	HOUSE_TYPE	Character	Optional	House type. Prompts from the translate values for the HOUSE_TYPE field.
10 (ADDRESS_SBR)	ADDR_FIELD1	Character	Optional	Address field 1. Prompts from the translate values for the ADDR_FIELD1 field.
11 (ADDRESS_SBR)	ADDR_FIELD2	Character	Optional	Address field 2.
12 (ADDRESS_SBR)	ADDR_FIELD3	Character	Optional	Address field 3.
13 (ADDRESS_SBR)	COUNTY	Character	Optional	County.
14 (ADDRESS_SBR)	STATE	Character	Optional	State.
15 (ADDRESS_SBR)	POSTAL	Character	Optional	Postal code.
16 (ADDRESS_SBR)	GEO_CODE	Character	Optional	Tax vendor geographic.
17 (ADDRESS_SBR)	IN_CITY_LIMIT	Character	Optional	Within city limit (yes or no).
92	EARLY_START_DT	Date	Optional	Early start date.
93	EARLY_FINISH_DT	Date	Optional	Early finish date.
94	ACTUAL_START_DT	Date	Optional	Actual start date.
95	ACTUAL_FINISH_DT	Date	Optional	Actual finish date.
96	BASELINE_START_DT	Date	Optional	Baseline start date.
97	BASELINE_FINISH_DT	Date	Optional	Baseline finish date.
98	LATE_START_DT	Date	Optional	Late start date.
99	LATE_FINISH_DT	Date	Optional	Late finish date.
100	PC_SCH_PRODUCT	Character	Optional	Third-party product code is a text field with no edit. The field is used for informational purposes only and can help reference the source system for the transaction.
101	PC_SCH_FIELD1	Character	Optional	Third-party project ID. If you import from a third-party product, this field is used to store the project ID that is from the third-party product.
102	PC_SCH_FIELD2	Character	Optional	Third-party project description up to 40 characters.
103	PC_SCH_FIELD3	Character	Required for tree integration	If you import from a third-party application, enter the unique node ID from the third-party application. If not, enter the project ID or WBS ID.
104	PC_SCH_FIELD4	Character	Optional	Node ID description.
105	PC_SCH_FIELD5	Character	Required for tree integration	Parent node ID. Only the root node (tree indent level 1) does not have a parent node ID.
106	PC_SCH_FIELD6	Character	Optional	Not used in the PeopleSoft Project Costing interface.
107	PC_SCH_FIELD7	Character	Optional	Not used for tree integration.
108	PC_SCH_FIELD8	Character	Optional	Can be used for the concatenation of this node to its parent and ancestors upward to the root node. For example, in AUTO.TRAIN.DOCS, AUTO is the root node, TRAIN is its child, and DOCS is its grandchild.
109	DESCRSHORT	Character	Optional	Short description for WBS ID.
110	PC_INDENT_LEVEL	Number	Required for tree integration	The level that is within the tree to which the current node belongs. Level 1 is the root node. There can be only one root node in a tree.
111	SUMMARY_PRJ	Character	Optional	Flag that designates if the project is a summary or a detail project. Default value is N (no).
112	ENFORCE	Character	Optional	Identifies the enforce project team option, such as PeopleSoft Expenses only, PeopleSoft Time and Labor only, Expenses and Time and Labor, or do not enforce. Default value is BUS_UNIT_OPT_PC.ENFORCE.
113	ENFORCE_TYPE	Character	Optional	Identifies the enforce project and activity team option, such as project and activity team, project team only, decide at the project level, or do not enforce. Default value is BUS_UNIT_OPT_PC.ENFORCE_TYPE.
114	PC_PROCESS_STATUS	Character	Optional	Provide a processing status value of A (active), I (inactive), or P (pending). If the source file does not contain a processing status, the default value is based on the Processing Status field on the Project Status Defaults page.
115	PROJ_REQUEST_ID	Character	Optional	Project request ID.
116	PPK_PROJ_VERSION	Character	Optional	Project request version.
117	PGM_SCHED_METHOD	Character	Optional	Schedule method, such as fixed units, duration, and work. Default value is BUS_UNIT_OPT_PC.PGM_SCHED_METHOD.
118	PC_PERCENT_DTTM	Date/Time	Optional	Percent complete date and time.
119	HOLIDAY_LIST_ID	Character	Optional	Holiday calendar. Default value is BUS_UNIT_OPT_PC.HOLIDAY_LIST_ID.
120	PLAN_STARTDT	Date	Optional	Planned start date.
121	PLAN_ENDDT	Date	Optional	Planned end date.
122	PLAN_PROJROLE	Character	Optional	Primary project role. Prompts from Project Role table (PROJ_ROLE).
123	PC_CALCULATE_SW	Character	Optional	Calculate manually, delay calculations until save, or calculate in real time. Default value is BUS_UNIT_OPT_PC.PC_CALCULATE_SW.
124	CONSTRAINT_DT_FLG	Character	Optional	Indicates that the system should always honor the constraint dates. Default value is Y (yes).
125	CHARGING_LEVEL	Character	Optional	The level of WBS activities that are available for charging, such as all detail activities, level 1, level 2, and level 3. Default value is from BUS_UNIT_OPT_PC.CHARGING_LEVEL.
126	CHARGING_LEVEL_TR	Character	Optional	The level of WBS activities that are available for charging on time reports from in PeopleSoft Expenses. Default value is from BUS_UNIT_OPT_PC.CHARGING_LEVEL_TR.
127	RATE_PLAN	Character	Optional	Not used in the PeopleSoft Project Costing interface. Note: The default value of the rate plan or rate set is based on the project type of the project or activity if you associate a predefined rate set or rate plan with the project type, and include the project type in the source file.
128	BUDGET_APPROVER	Character	Optional	Prompts from PC_CHC_BUD_APR table.
129	SCEN_ADJUST_PCT_TM	Sign	Optional	Scenario adjustment percent for time.
130	SCEN_ADJUST_PCT_EX	Sign	Optional	Scenario adjustment percent for expenses.
131	MANAGED_BY_WO	Character	Optional	Indicates if a project is managed by a work order. Default value is N (no).
132	PC_REV_BUD_AN_GRP	Character	Optional	Prompts from SP_AN_GRP_NONVW table.
133	AN_GRP_TOT_REV	Character	Optional	Prompts from the SP_AN_GRP_NONVW table.
134	AN_GRP_EAC	Character	Optional	Analysis group that represents the estimate at completion forecast. Prompts from the SP_AN_GRP_NONVW table.
135	RETAIN_HISTORY	Character	Optional	Indicates how often history is retained. The default value is based on the business unit.