Understanding PeopleSoft Project Costing Interface Data Structures
This topic discusses:
Interface table key database fields.
Projects Interface staging table structure.
Activities Interface staging table structure.
Resources Interface staging table structure.
Transactions Interface table structure.
The Projects Interface, Activities Interface, Resources Interface, and Transactions Interface tables use these key database fields, which must be populated for each row of data:
Term |
Definition |
---|---|
Interface Identifier field (INTFC_ID) |
Identifies a batch of transactions that you send to the interface table. The value increases by one every time that a batch populates the table. You can specify a range of interface identifiers to process multiple batches on the run control page. |
Interface Line Number field (INTFC_LINE_NUM) |
Uniquely identifies every line that belongs to a batch with the same interface ID. |
Additional key database fields in the Projects Interface staging table are Business Unit (BUSINESS_UNIT) and Project (PROJECT_ID). Additional key database fields in the Activities Interface staging table are Business Unit, Project, and Activity (ACTIVITY_ID). Additional key database fields in the Resources Interface staging table are Business Unit, Project, Activity, Team Classification (TEAM_MEMBER_CLASS), Team Identifier (TEAM_MEMBER_IND), and Team Member (TEAM_MEMBER).
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. |
This table lists the details of the Activities 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 |
Conditional |
You can bulk load projects and use the system autonumbering functionality to generate the next PROJECT_ID. In this case, PROJECT_IDs are not required. However, if you perform update projects or incrementally add activities to projects, then PROJECT_IDs are required and are validated against the PROJECT table. |
5 |
ACTIVITY_ID |
Character |
Conditional |
You can bulk load activities and use the system autonumbering functionality to generate the next ACTIVITY_ID. In this case, ACTIVITY_IDs are not required. However, if you perform updates or incrementally add activities to projects, then ACTIVITY_IDs are required and are validated against the PROJ_ACTIVITY table. |
6 |
INTFC_TYPE |
Character |
Optional |
Not used in the activity interface. |
7 |
INTFC_STATUS |
Character |
Optional |
Populate the field with NEW. |
8 |
LOAD_STATUS |
Character |
Optional |
Populate the field with NEW. |
9 |
ORIG_INTFC_ID |
Number |
Optional |
Not used in the activity interface. |
10 |
ORIG_LINE_NUM |
Number |
Optional |
Not used in the activity interface. |
11 |
ACTIVITY_DESCR |
Character |
Optional |
Activity description up to 30 characters. |
12 |
ACTIVITY_TYPE |
Character |
Optional |
Prompts from the PROJ_ACT_TBL table. |
13 |
SYSTEM_SOURCE |
Character |
Optional |
Populate the field with BPC (batch process). |
14 |
PERCENT_COMPLETE |
Number |
Optional |
Schedule status percent complete. |
15 |
EARLY_START_DT |
Date |
Optional |
Early start date. |
16 |
LATE_START_DT |
Date |
Optional |
Late start date. |
17 |
ACTUAL_START_DT |
Date |
Optional |
Actual start date. |
18 |
EARLY_FINISH_DT |
Date |
Optional |
Early finish date. |
19 |
LATE_FINISH_DT |
Date |
Optional |
Late finish date. |
20 |
ACTUAL_FINISH_DT |
Date |
Optional |
Actual finish date. |
21 |
BASELINE_FINISH_DT |
Date |
Optional |
Baseline finish date. |
22 |
BASELINE_START_DT |
Date |
Optional |
Baseline start date. |
23 |
BCWP |
Number |
Optional |
Work performed. |
24 |
BCWS |
Number |
Optional |
Work scheduled. |
25 |
ACT_TYPE_SCH |
Character |
Optional |
Schedule activity type. Prompts from the PC_ACT_TYPE_SCH table. |
26 |
DTTM_STAMP |
Date/Time |
System-maintained |
Date and time when the project is created. |
27 |
DRAWING_NAME |
Character |
Optional |
Not used in the activity interface. |
28 |
ACTIVITY_USER1 |
Character |
Optional |
User-defined field. |
29 |
ACTIVITY_USER2 |
Character |
Optional |
User-defined field. |
30 |
ACTIVITY_USER3 |
Character |
Optional |
User-defined field. |
31 |
ACTIVITY_USER4 |
Character |
Optional |
User-defined field. |
32 |
ACTIVITY_USER5 |
Character |
Optional |
User-defined field. |
33 |
PC_ACT_USER_DT1 |
Date |
Optional |
User-defined field. |
34 |
PC_ACT_USER_DT2 |
Date |
Optional |
User-defined field. |
35 |
PC_USER_CURRENCY |
Character |
Optional |
User-defined field. Prompts from the CURRENCY_CD_TBL table. |
36 |
PC_ACT_USERAMT1 |
Sign |
Optional |
User-defined field. |
37 |
PC_ACT_USERAMT2 |
Sign |
Optional |
User-defined field. |
38 |
PC_ACT_USERAMT3 |
Sign |
Optional |
User-defined field. |
39 |
SETID |
Character |
Required |
Not used in the activity interface. |
40 |
OPRID |
Character |
Optional |
The interface assigns an operator ID. |
41 |
PROCESS_INSTANCE |
Number |
System-maintained |
The interface assigns a process instance number. |
42 |
DESCR254 |
Character |
Optional |
Activity description up to 254 characters. |
43 |
ACT_LOC_EFFDT |
Date |
Optional |
Activity location effective date. Populated with %Date (current server date) if not provided in the source file. |
44 |
EFFSEQ |
Number |
Optional |
Activity location effective sequence or activity status effective sequence. Default value is 1. |
45 |
LOCATION |
Character |
Optional |
Must be a value from the LOCATION_TBL table. Default value is from LOCATION_TBL.LOCATION. |
46 |
LOCATION_FRACTION |
Number |
Optional |
Not used in the activity interface. |
47 |
ACTIVITY_STATUS |
Character |
Optional |
Activity status. Prompts from the PROJ_STATUS_TBL table. |
48 |
ACT_STATUS_EFFDT |
Date |
Optional |
Activity status effective date. Populated with %Date (current server date) if not provided in the source file. |
49 |
START_DT_2 |
Date |
Optional |
User-defined field. |
50 |
END_DT_2 |
Date |
Optional |
User-defined field. |
51 |
START_DT |
Date |
Required |
Activity start date. |
52 |
END_DT |
Date |
Required |
Activity end date. |
53 |
ACTIVITY_PRIORITY |
Number |
Optional |
Activity priority. |
54 |
ACT_PCT_COMPLETE |
Number |
Optional |
Activity percentage complete. |
55 |
QUALITY_DTTM |
Date/Time |
System-maintained |
Date and time when the record is created. |
56 |
QUALITY_TYPE |
Character |
Optional |
Prompts from the PROJ_QUAL_TBL table. |
57 |
QUALITY_RATING |
Number |
Optional |
Not used in the activity interface. |
58 |
QUALITY_WEIGHT |
Number |
Optional |
Not used in the activity interface. |
59 |
QUALITY_MEMBER |
Character |
Optional |
Prompts from the PROJ_TEAM_VW table. |
60 |
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) |
NUM6 |
Character |
Optional |
Number 6. |
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). |
61 |
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. |
62 |
PC_MILESTONE_FLG |
Character |
Conditional |
Indicates if activity is a milestone. |
63 |
AFUDC_ACT_SW |
Character |
Conditional |
Allows interest calculations for this project activity. |
64 |
ACT_TEMPLATE_SW |
Character |
Not used in the PeopleSoft Project Costing interface. |
|
65 |
PC_SCH_FIELD1 |
Character |
Optional |
Third-party user field. |
66 |
PC_SCH_FIELD2 |
Character |
Optional |
Third-party user field. |
67 |
PC_SCH_FIELD3 |
Character |
Optional |
Third-party user field. |
68 |
PC_SCH_FIELD4 |
Character |
Optional |
Third-party user field. |
69 |
PC_SCH_FIELD5 |
Character |
Optional |
Third-party user field. |
70 |
PC_SCH_FIELD6 |
Character |
Optional |
Third-party user field. |
71 |
PC_SCH_FIELD7 |
Character |
Optional |
Third-party user field. |
72 |
SUMMARY_ACT |
Character |
Optional |
Designates an activity as a summary activity. The default value is N (no). |
73 |
PC_DURATION |
Number |
Duration. |
|
74 |
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. |
75 |
PC_CHC_ACT_SW |
Character |
Optional |
Enables change control. Default value is PROJECT.PC_CHC_SW. |
76 |
PGM_SCHED_METHOD |
Character |
Optional |
Schedule method, such as fixed units, duration, and work. Default value is PROJECT.PGM_SCHED_METHOD. |
77 |
WBS_ID |
Character |
Optional |
Coded hierarchy identifier for each activity. |
78 |
PGM_WBS_SBR |
Subrecord |
Optional |
Hierarchy grid subrecord. |
1 (PGM_WBS_SBR) through 26 (PGM_WBS_SBR) |
LEVEL1 through LEVEL 26 |
Number |
Optional |
|
79 |
LEVEL_NUM |
Number |
Optional |
|
80 |
ROW_NUMBER_5 |
Number |
Optional |
Internal sequence number assigned to each row to uniquely identify a row. |
81 |
DEADLINE_DT |
Date |
Optional |
Deadline date. |
82 |
CONSTRAINT_DT |
Date |
Optional |
Constraint date. |
83 |
CONSTRAINT_TYPE |
Character |
Optional |
Constraint type. |
84 |
COSTING_ACT_SW |
Character |
Optional |
Activity costing flag. Indicates whether an activity is available for charging. |
85 |
PC_ACT_OWNER |
Character |
Optional |
Activity owner. Prompts from PC_TEAM_PROM_VW table. |
86 |
CURRENCY_CD |
Character |
Optional |
Default value is PROJECT.CURRENCY_CD. |
87 |
PC_ACT_DEF_CALC_MT |
Character |
Optional |
Activity calculation method. Default value is PROJECT.PC_ACT_DEF_CALC_MT. |
This table lists the details of the Resources 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 |
ACTIVITY_ID |
Character |
Optional |
Required if loading activity team member. Otherwise, leave blank for project team member. |
6 |
TEAM_MEMBER_CLASS |
Character |
Required |
“L” for labor, “M” for material, “A” for equipment asset. |
7 |
TEAM_MEMBER_IND |
Character |
Required |
For named resources, use “E”. For generic resources, use “G” if labor resource, else use “N” for material or equipment asset generic resource. |
8 |
TEAM_MEMBER |
Character |
Required |
For named resources, this is the unique valid resource ID. For generic resources, this is a generic text field. |
9 |
PLAN_STARTDT |
Character |
Optional |
Required if adding project team member. Indicates the planned start date the resource is assigned to the project. |
10 |
PLAN_ENDDT |
Character |
Optional |
Required if adding project team member. Indicates the planned end date the resource is assigned to the project. |
11 |
PROJ_ROLE |
Character |
Optional |
Required for labor resource. Prompts from the PROJ_ROLE table. |
12 |
BUSINESS_UNIT_AM |
Character |
Optional |
Required for equipment asset resource. The Asset Management business unit associated with the resource. |
13 |
ASSET_TYPE |
Character |
Optional |
Required for equipment asset resource. The type of asset. |
14 |
ASSET_SUBTYPE |
Character |
Optional |
Required for equipment asset resource. Prompts from the AM_SUBTYPE table. |
15 |
MODEL |
Character |
Optional |
Optional for equipment asset resource. Prompts from the MFG_MODEL equipment asset. |
16 |
MFG_ID |
Character |
Optional |
Optional for equipment asset resource. Prompts from the MANUFACTURER table. |
17 |
AVAIL_UNITS |
Number |
Optional |
Not used if loading project team member. For activity team member:
|
18 |
UNIT_OF_MEASURE |
Character |
Optional |
Not used if loading project team member. For activity team member, this is the unit of measure associated with the quantity, cost, and bill rates. Prompts from the UNITS_TBL table. |
19 |
PGM_RATE_TYPE |
Character |
Optional |
Indicates the source of the cost rate. “C” is for customer rate. “J” is for job code rate (for labor only. “E” is for employee rate (for labor only). “R” is for role rate (for labor only). |
20 |
COST_RATE |
Number |
Optional |
The cost rate for the resource. |
21 |
CURRENCY_CD |
Character |
Optional |
The currency code associated with the cost rate. Prompts for the CURRENCY_CD_TBL table. |
22 |
BILL_RATE |
Number |
Optional |
The bill rate for the resource. |
23 |
BILL_RATE_TYPE_1 |
Character |
Optional |
Indicates the source of the billing rate. “C” is for customer rate. “J” is for jobcode rate (for labor only). “E” is for employee rate (for labor only). “R” is for role rate (for labor only). |
24 |
BILL_CURRENCY_CD |
Character |
Optional |
The currency code associated with the billing rate. Prompts for the CURRENCY_CD_TBL table. |
25 |
ASSGND_WORK |
Number |
Optional |
For labor resources only. Not used if loading project team member. For activity team member, this is the number of days, or hours, to which the resource is assigned. The units will be based on the unit of measure field. |
26 |
BASELINE_WORK |
Number |
Optional |
For labor resources only. For information only. Not used if loading project team member. For activity team member, this is the baseline (original) number of days, or hours, to which the resource is assigned. The units will be based on the unit of measure field. |
27 |
INTFC_STATUS |
Character |
Optional |
Set to “NEW” for loading. This will get updated to “DON” if loaded successfully, or “ERR” if an error is encountered. |
28 |
LOAD_STATUS |
Character |
Optional |
Populated in the Application Engine with NEW if not provided in the source file. |
29 |
SOURCE_FLAG |
The source where the team was created:
|
||
30 |
ERR_REASON |
Can be left blank for loading. If an error is encountered during the load, this field is populated with the reason code. |
||
31 |
PC_DURATION |
Can be left blank for loading. |
||
32 |
P6_MERGED_ASSIGNMT |
For Primavera P6 processing only. |
||
33 |
PROJECT_OBJECTID |
For Primavera P6 processing only. |
||
34 |
ACTIVITY_OBJECTID |
For Primavera P6 processing only. |
||
35 |
RESASSIGN_OBJECTID |
For Primavera P6 processing only. |
||
36 |
P6_TSKRS_GUID |
For Primavera P6 processing only. |
This table lists the details of the Project Transaction Interface 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 |
PC_RES_INTF_SBR |
Subrecord |
||
1 (PC_RES_INTF_SBR) |
BUSINESS_UNIT |
Character |
Required |
Prompts from the SP_BU_PC_NONVW table. |
2 (PC_RES_INTF_SBR) |
PROJECT_ID |
Character |
Required |
Prompts from the SP_PROJ_NONVW table. |
3 (PC_RES_INTF_SBR) |
ACTIVITY_ID |
Character |
Required |
Prompts from the PROJ_ACT_VW table. |
4 (PC_RES_INTF_SBR) |
RESOURCE_ID |
Character |
Optional |
Resource ID. |
5 (PC_RES_INTF_SBR) |
RESOURCE_ID_FROM |
Character |
Optional |
Resource ID from. |
6 (PC_RES_INTF_SBR) |
BUSINESS_UNIT_GL |
Character |
Required |
Prompts from the SP_BUPCIT_NONVW table. |
7 (PC_RES_INTF_SBR) |
BUSINESS_UNIT_PC |
Character |
Optional |
Project business unit. |
8 (PC_RES_INTF_SBR) |
JOURNAL_ID |
Character |
Optional |
Journal ID. |
9 (PC_RES_INTF_SBR) |
JOURNAL_DATE |
Date |
Optional |
Journal date. |
10 (PC_RES_INTF_SBR) |
UNPOST_SEQ |
Number |
Optional |
Unpost sequence. |
11 (PC_RES_INTF_SBR) |
JOURNAL_LINE |
Number |
Optional |
General ledger journal line number. |
12 (PC_RES_INTF_SBR) |
FISCAL_YEAR |
Number |
Optional |
Fiscal year. |
13 (PC_RES_INTF_SBR) |
ACCOUNTING_PERIOD |
Number |
Optional |
Accounting period. |
14 (PC_RES_INTF_SBR) |
ACCOUNT |
Character |
Optional |
Prompts from the GL_ACCT_BUGL_VW table. |
15 (PC_RES_INTF_SBR) |
ALTACCT |
Character |
Optional |
Prompts from the ALT_BUGL_VW table. |
16 (PC_RES_INTF_SBR) |
DEPTID |
Character |
Optional |
Prompts from the DEPTID_BUGL_VW table. |
17 (PC_RES_INTF_SBR) |
CF16_AN_SBR |
Character |
Optional |
ChartField subrecord. |
1 (CF16_AN_SBR) |
OPERATING_UNIT |
Character |
Optional |
Prompts from the OPERUNT_BUGL_VW table. |
2 (CF16_AN_SBR) |
PRODUCT |
Character |
Optional |
Prompts from the PRODUCT_BUGL_VW table. |
3 (CF16_AN_SBR) |
FUND_CODE |
Character |
Optional |
Prompts from the FUND_BUGL_VW table. |
4 (CF16_AN_SBR) |
CLASS_FLD |
Character |
Optional |
Prompts from the CLASSCF_BUGL_VW table. |
5 (CF16_AN_SBR) |
PROGRAM_CODE |
Character |
Optional |
Prompts from the PROGRAM_BUGL_VW table. |
6 (CF16_AN_SBR) |
BUDGET_REF |
Character |
Optional |
Prompts from the BUD_REF_BUGL_VW table. |
7 (CF16_AN_SBR) |
AFFILIATE |
Character |
Optional |
Prompts from the AFFILIATE_VW table. |
8 (CF16_AN_SBR) |
AFFILIATE_INTRA1 |
Character |
Optional |
Intraunit affiliate 1. |
9 (CF16_AN_SBR) |
AFFILIATE_INTRA2 |
Character |
Optional |
Intraunit affiliate 2. |
10 (CF16_AN_SBR) |
CHARTFIELD1 |
Character |
Optional |
Prompts from the CF1_BUGL_VW table. |
11 (CF16_AN_SBR) |
CHARTFIELD2 |
Character |
Optional |
Prompts from the CF2_BUGL_VW table. |
12 (CF16_AN_SBR) |
CHARTFIELD3 |
Character |
Optional |
Prompts from the CF3_BUGL_VW table. |
18 (PC_RES_INTF_SBR) |
BUS_UNIT_GL_FROM |
Character |
Optional |
Prompts from the Integration Template General Ledger table (PC_INT_TMPL_GL). |
19 (PC_RES_INTF_SBR) |
CURRENCY_CD |
Character |
Optional |
Prompts from the Currency Codes table (CURRENCY_CD_TBL). |
20 (PC_RES_INTF_SBR) |
STATISTICS_CODE |
Character |
Optional |
Prompts from the STAT_BUGL_VW table. |
21 (PC_RES_INTF_SBR) |
LEDGER_GROUP |
Character |
Optional |
Prompts from the SP_LEDGPC_NONVW table. |
22 (PC_RES_INTF_SBR) |
ANALYSIS_TYPE |
Character |
Required |
Analysis type. |
23 (PC_RES_INTF_SBR) |
RESOURCE_TYPE |
Character |
Optional |
Prompts from the Project Resource Type table (PROJ_RES_TYPE). |
24 (PC_RES_INTF_SBR) |
RESOURCE_CATEGORY |
Character |
Optional |
Category. |
25 (PC_RES_INTF_SBR) |
RESOURCE_SUB_CAT |
Character |
Optional |
Subcategory. |
26 (PC_RES_INTF_SBR) |
RES_USER1 |
Character |
Optional |
Transaction user 1. |
27 (PC_RES_INTF_SBR) |
RES_USER2 |
Character |
Optional |
Transaction user 2. |
28 (PC_RES_INTF_SBR) |
RES_USER3 |
Character |
Optional |
Transaction user 3. |
29 (PC_RES_INTF_SBR) |
RES_USER4 |
Character |
Optional |
Transaction user 4. |
30 (PC_RES_INTF_SBR) |
RES_USER5 |
Character |
Optional |
Transaction user 5. |
31 (PC_RES_INTF_SBR) |
TRANS_DT |
Date |
Optional |
Transaction date. |
32 (PC_RES_INTF_SBR) |
ACCOUNTING_DT |
Date |
Optional |
Accounting date. |
33 (PC_RES_INTF_SBR) |
JRNL_LN_REF |
Character |
Optional |
Journal line reference. |
34 (PC_RES_INTF_SBR) |
OPEN_ITEM_STATUS |
Character |
Optional |
Prompts from the field's translate values. |
35 (PC_RES_INTF_SBR) |
LINE_DESCR |
Character |
Optional |
Journal line description. |
36 (PC_RES_INTF_SBR) |
JRNL_LINE_STATUS |
Character |
Optional |
Prompts from the field's translate values. |
37 (PC_RES_INTF_SBR) |
JOURNAL_LINE_DATE |
Date |
Optional |
Journal line date. |
38 (PC_RES_INTF_SBR) |
FOREIGN_CURRENCY |
Character |
Optional |
Prompts from the FRGN_CURR_VW table. |
39 (PC_RES_INTF_SBR) |
RT_TYPE |
Character |
Optional |
Prompts from the Market Rate Data Types table (RT_TYPE_TBL). |
40 (PC_RES_INTF_SBR) |
FOREIGN_AMOUNT |
Sign |
Optional |
Foreign amount. |
41 (PC_RES_INTF_SBR) |
RATE_MULT |
Sign |
Optional |
Rate multiplier. |
42 (PC_RES_INTF_SBR) |
RATE_DIV |
Number |
Optional |
Rate divisor. |
43 (PC_RES_INTF_SBR) |
CUR_EFFDT |
Date |
Optional |
Currency effective date. |
44 (PC_RES_INTF_SBR) |
PROCESS_INSTANCE |
Number |
Optional |
Process instance. |
45 (PC_RES_INTF_SBR) |
PC_DISTRIB_STATUS |
Character |
Optional |
Prompts from the field's translate values. |
46 (PC_RES_INTF_SBR) |
GL_DISTRIB_STATUS |
Character |
Optional |
Prompts from the field's translate values. |
47 (PC_RES_INTF_SBR) |
PROJ_TRANS_TYPE |
Character |
Optional |
Prompts from the Project Transaction Types table (PROJ_TRANS_TYPE). |
48 (PC_RES_INTF_SBR) |
PROJ_TRANS_CODE |
Character |
Optional |
Prompts from the Project Transaction Codes table (PROJ_TRANS_CODE). |
49 (PC_RES_INTF_SBR) |
RESOURCE_STATUS |
Character |
Optional |
Transaction status. |
50 (PC_RES_INTF_SBR) |
DESCR |
Character |
Optional |
Description. |
51 (PC_RES_INTF_SBR) |
SYSTEM_SOURCE |
Character |
Optional |
Prompts from the field's translate values. |
52 (PC_RES_INTF_SBR) |
UNIT_OF_MEASURE |
Character |
Optional |
Prompts from the Units of Measure table (UNITS_TBL). |
53 (PC_RES_INTF_SBR) |
EMPLID |
Character |
Optional |
Prompts from the PROJ_TEAM_VW table. |
54 (PC_RES_INTF_SBR) |
EMPL_RCD |
Number |
Optional |
Employee record number. |
55 (PC_RES_INTF_SBR) |
SEQ_NBR |
Number |
Optional |
Sequence number. |
56 (PC_RES_INTF_SBR) |
TIME_RPTG_CD |
Character |
Optional |
Time reporting code. |
57 (PC_RES_INTF_SBR) |
JOBCODE |
Character |
Optional |
Job code. |
58 (PC_RES_INTF_SBR) |
COMPANY |
Character |
Optional |
Company. |
59 (PC_RES_INTF_SBR) |
BUSINESS_UNIT_AP |
Character |
Optional |
Prompts from the SP_BU_AP_NONVW table. |
60 (PC_RES_INTF_SBR) |
VENDOR_ID |
Character |
Optional |
Prompts from the PROJ_VENDOR_VW table. |
61 (PC_RES_INTF_SBR) |
VOUCHER_ID |
Character |
Optional |
Voucher ID. |
62 (PC_RES_INTF_SBR) |
VOUCHER_LINE_NUM |
Number |
Optional |
Voucher line number. |
63 (PC_RES_INTF_SBR) |
APPL_JRNL_ID |
Character |
Optional |
Prompts from the Journal Generator template table (JRNLGEN_APPL_ID). |
64 (PC_RES_INTF_SBR) |
PYMNT_CNT |
Number |
Optional |
Payments. |
65 (PC_RES_INTF_SBR) |
DST_ACCT_TYPE |
Character |
Optional |
Prompts from the field's translate values. |
66 (PC_RES_INTF_SBR) |
PO_DISTRIB_STATUS |
Character |
Optional |
Prompts from the field's translate values. |
67 (PC_RES_INTF_SBR) |
BUSINESS_UNIT_PO |
Character |
Optional |
Prompts from the SP_BU_PM_NONVW table. |
68 (PC_RES_INTF_SBR) |
REQ_ID |
Character |
Optional |
Requisition ID. |
69 (PC_RES_INTF_SBR) |
REQ_LINE_NBR |
Number |
Optional |
Requisition line number. |
70 (PC_RES_INTF_SBR) |
REQ_SCHED_NBR |
Number |
Optional |
Requisition schedule number. |
71 (PC_RES_INTF_SBR) |
REQ_DISTRIB_NBR |
Number |
Optional |
Requisition distribution number. |
72 (PC_RES_INTF_SBR) |
PO_ID |
Character |
Optional |
Purchase order number. |
73 (PC_RES_INTF_SBR) |
DUE_DATE |
Date |
Optional |
Delivery due date from. |
74 (PC_RES_INTF_SBR) |
LINE_NBR |
Number |
Optional |
Line number. |
75 (PC_RES_INTF_SBR) |
SCHED_NBR |
Number |
Optional |
Schedule number. |
76 (PC_RES_INTF_SBR) |
DISTRIB_LINE_NUM |
Number |
Optional |
Distribution line. |
77 (PC_RES_INTF_SBR) |
AM_DISTRIB_STATUS |
Character |
Optional |
Prompts from the field's translate values. |
78 (PC_RES_INTF_SBR) |
BUSINESS_UNIT_AM |
Character |
Optional |
Prompts from the SP_BU_AM_NONVW table. |
79 (PC_RES_INTF_SBR) |
ASSET_ID |
Character |
Optional |
Prompts from the PROJ_ASSET_VW table. |
80 (PC_RES_INTF_SBR) |
PROFILE_ID |
Character |
Optional |
Prompts from the PROFILE_PCAM_VW table. |
81 (PC_RES_INTF_SBR) |
COST_TYPE |
Character |
Optional |
Prompts from the Asset Cost Type Definition table (COST_TYPE_TBL). |
82 (PC_RES_INTF_SBR) |
BOOK |
Character |
Optional |
Asset book name. |
83 (PC_RES_INTF_SBR) |
INCENTIVE_ID |
Character |
Optional |
Prompts from the PC_PROJ_GNT_VW table. |
84 (PC_RES_INTF_SBR) |
MSTONE_SEQ |
Number |
Optional |
Milestone sequence. |
85 (PC_RES_INTF_SBR) |
CONTRACT_NUM |
Character |
Optional |
Prompts from the CA_CONTRACT_VW table. |
86 (PC_RES_INTF_SBR) |
CONTRACT_LINE_NUM |
Number |
Optional |
Contract line number. |
87 (PC_RES_INTF_SBR) |
CONTRACT_PPD_SEQ |
Number |
Optional |
Prepaid add sequence. |
88 (PC_RES_INTF_SBR) |
BI_DISTRIB_STATUS |
Character |
Optional |
Prompts from the field's translate values. |
89 (PC_RES_INTF_SBR) |
BUSINESS_UNIT_BI |
Character |
Optional |
Prompts from the SP_BU_BI_NONVW table. |
90 (PC_RES_INTF_SBR) |
BILLING_DATE |
Date |
Optional |
Billing date. |
91 (PC_RES_INTF_SBR) |
INVOICE |
Character |
Optional |
Invoice. |
92 (PC_RES_INTF_SBR) |
REV_DISTRIB_STATUS |
Character |
Optional |
Prompts from the field's translate values. |
93 (PC_RES_INTF_SBR) |
BUSINESS_UNIT_AR |
Character |
Optional |
Prompts from the SP_BUARED_NONVW table. |
94 (PC_RES_INTF_SBR) |
CUST_ID |
Character |
Optional |
Prompts from the PROJ_CUST_VW table. |
95 (PC_RES_INTF_SBR) |
ITEM |
Character |
Optional |
Prompts from the ITEM_OPEN_PC_VW table. |
96 (PC_RES_INTF_SBR) |
ITEM_LINE |
Number |
Optional |
Item line. |
97 (PC_RES_INTF_SBR) |
ITEM_SEQ_NUM |
Number |
Optional |
Item sequence number. |
98 (PC_RES_INTF_SBR) |
DST_SEQ_NUM |
Number |
Optional |
Distribution sequence. |
99 (PC_RES_INTF_SBR) |
BUSINESS_UNIT_IN |
Character |
Optional |
Prompts from the SP_BUIN_NONVW table. |
100 (PC_RES_INTF_SBR) |
SCHED_LINE_NO |
Number |
Optional |
Schedule line number. |
101 (PC_RES_INTF_SBR) |
DEMAND_LINE_NO |
Number |
Optional |
Demand line number. |
102 (PC_RES_INTF_SBR) |
INV_ITEM_ID |
Character |
Optional |
Prompts from the PROJ_ITEM_VW table. |
103 (PC_RES_INTF_SBR) |
PAY_END_DT |
Date |
Optional |
Pay period end date. |
104 (PC_RES_INTF_SBR) |
BUSINESS_UNIT_OM |
Character |
Optional |
Prompts from the SP_BUPCOM_NONVW table. |
105 (PC_RES_INTF_SBR) |
ORDER_NO |
Character |
Optional |
Order number. |
106 (PC_RES_INTF_SBR) |
ORDER_INT_LINE_NO |
Number |
Optional |
Order line number. |
107 (PC_RES_INTF_SBR) |
EX_DOC_ID |
Character |
Optional |
PeopleSoft Expenses document ID. |
108 (PC_RES_INTF_SBR) |
EX_DOC_TYPE |
Character |
Optional |
Prompts from the field's translate values. |
109 (PC_RES_INTF_SBR) |
RESOURCE_QUANTITY |
Sign |
Optional |
Quantity. |
110 (PC_RES_INTF_SBR) |
RESOURCE_AMOUNT |
Sign |
Optional |
Project business unit amount. |
111 (PC_RES_INTF_SBR) |
BUDGET_HDR_STATUS |
Character |
Optional |
Prompts from the field's translate values. |
112 (PC_RES_INTF_SBR) |
KK_AMOUNT_TYPE |
Character |
Optional |
Prompts from the field's translate values. |
113 (PC_RES_INTF_SBR) |
KK_TRAN_OVER_FLAG |
Character |
Optional |
Override transaction. |
114 (PC_RES_INTF_SBR) |
KK_TRAN_OVER_OPRID |
Character |
Optional |
Override user ID. |
115 (PC_RES_INTF_SBR) |
KK_TRAN_OVER_DTTM |
DtTm |
Optional |
Override date. |
116 (PC_RES_INTF_SBR) |
BUDGET_OVER_ALLOW |
Character |
Optional |
Budget overrun allowed. |
117 (PC_RES_INTF_SBR) |
BUDGET_LINE_STATUS |
Character |
Optional |
Prompts from the field's translate values. |
118 (PC_RES_INTF_SBR) |
BUDGET_DT |
Date |
Optional |
Budget date. |
119 (PC_RES_INTF_SBR) |
LEDGER |
Character |
Optional |
Prompts from the SP_LEDPC_NONVW table. |
120 (PC_RES_INTF_SBR) |
BD_DISTRIB_STATUS |
Character |
Optional |
Prompts from the translate values of the field. |
121 (PC_RES_INTF_SBR) |
BUSINESS_UNIT_BD |
Character |
Optional |
Prompts from the SP_BUPCBD_NONVW table. |
122 (PC_RES_INTF_SBR) |
FA_STATUS |
Character |
Optional |
F&A status. |
123 (PC_RES_INTF_SBR) |
TIME_SHEET_ID |
Character |
Optional |
Time report ID. |
124 (PC_RES_INTF_SBR) |
SHEET_ID |
Character |
Optional |
Report ID. |
125 (PC_RES_INTF_SBR) |
DT_TIMESTAMP |
DtTm |
Optional |
Date timestamp. |
126 (PC_RES_INTF_SBR) |
VCHR_DIST_LINE_NUM |
Number |
Optional |
Distribution line number. |
127 (PC_RES_INTF_SBR) |
PM_REVIEWED |
Character |
Optional |
Prompts from the field's translate values. |
128 (PC_RES_INTF_SBR) |
PRICED_RATE |
Sign |
Optional |
Priced rate. |
129 (PC_RES_INTF_SBR) |
ACTIVITY_ID_DETAIL |
Character |
Optional |
Prompts from the Activity ID Detail Prompt table (PC_ACT_DETAIL). |
130 (PC_RES_INTF_SBR) |
CST_DISTRIB_STATUS |
Character |
Optional |
Prompts from the field's translate values. |
131 (PC_RES_INTF_SBR) |
TXN_LMT_TRANS_ID |
Character |
Optional |
Transaction limit ID. |
132 (PC_RES_INTF_SBR) |
EVENT_NUM |
Number |
Optional |
Event number. |
133 (PC_RES_INTF_SBR) |
CA_FEE_STATUS |
Character |
Optional |
Prompts from the field's translate values. |
134 (PC_RES_INTF_SBR) |
WM_WO_SBR |
Subrecord |
Optional |
PeopleSoft Maintenance Management work order subrecord. |
1 (WM_WO_SBR) |
BUSINESS_UNIT_WO |
Character |
Optional |
Work order business unit. Prompts from the SP_BU_WM_NONVW table. |
2 (WM_WO_SBR) |
WO_ID |
Character |
Optional |
Work order ID. Prompts from the WM_WO_NOT_CLSD table. |
3 (WM_WO_SBR) |
WO_TASK_ID |
Number |
Optional |
Task number. Prompts from the WM_WO_TSK_NCLSD table. |
4 (WM_WO_SBR) |
RSRC_TYPE |
Character |
Optional |
Resource type. Prompts from the translate values of the field. |
5 (WM_WO_SBR) |
RES_LN_NBR |
Number |
Optional |
Resource line number. |
135 (PC_RES_INTF_SBR) |
FMS_WHO_SBR |
Subrecord |
Optional |
Date, time, and operator subrecord. |
1 (FMS_WHO_SBR) |
FMS_DTTM_STAMP |
DtTm |
Optional |
Date/time stamp. |
2 (FMS_WHO_SBR) |
FMS_OPRID |
Character |
Optional |
Operator ID. |
3 (FMS_WHO_SBR) |
FMS_LASTUPDDTTM |
DtTm |
Optional |
Last update date/time. |
4 (FMS_WHO_SBR) |
FMS_LASTUPDOPRID |
Character |
Optional |
Last update user ID. |
4 |
INTFC_TYPE |
Character |
Optional |
Not used in the transactions interface. |
5 |
PC_INTFC_STATUS |
Character |
Required |
Populate the field with NEW. |
6 |
PC_LOAD_STATUS |
Character |
Required |
Populate the field with NEW. |
7 |
START_DT |
Date |
|
|
8 |
ORIG_INTFC_ID |
Number |
Optional |
Not used in the transactions interface. |
9 |
ORIG_LINE_NUM |
Number |
Optional |
Not used in the transactions interface. |
10 |
INTEGRATION_TMPL |
Character |
Optional |
Not used in the transactions interface. |
11 |
QUANTITY |
Sign |
|
Quantity interface. |
12 |
DESCR254 |
Character |
Optional |
Not used in the transactions interface. |
13 |
SETID |
Character |
System-maintained |
Not used in the transactions interface. |
14 |
MESSAGE_SET_NBR |
Number |
System-maintained |
Edit errors message set. |
15 |
MESSAGE_NBR |
Number |
System-maintained |
Edit errors message number. |
16 |
COMBO_STATUS |
Character |
Conditional |
Populate the field with V (valid) if ChartField combination edits are performed. |
17 |
CURRENCY_CD_GL |
Character |
System-maintained |
Used in Commitment Control budgeting. |
18 |
MONETARY_AMOUNT |
Sign |
System-maintained |
Used in Commitment Control budgeting. |
19 |
KK_DISTRIB_STATUS |
Character |
Optional |
Populate this field with N (none) if the transaction is to be billed. If the transaction needs to be budget checked, provide a value of B. The default value is N if a value is not provided in the source table. |
20 |
KK_SOURCE_TRAN |
Character |
Optional |
Not used in the transactions interface. |
21 |
PC_MSP_AE6 |
Character |
Optional |
Not used in the transactions interface. |
22 |
PC_MSP_AE2 |
Character |
Optional |
Not used in the transactions interface. |
23 |
PC_MSP_AE6 |
Character |
Conditional |
Not used in the transactions interface. |
24 |
FIELDNAME |
Character |
System-maintained |
Edit errors field name. |
25 |
PC_BUDGET_ID |
Number |
Optional |
Budget plan ID. If the budget ID does not exist in the Project Budget Plan table (PC_BUD_PLAN), the process creates a budget ID, indicating that a new budget is being integrated. |
26 |
BUDGET_PERIOD |
Character |
Conditional |
Budget period. This field is required if the analysis type provided for the transaction line is from the Budget analysis group that is specified at the installation level. |
27 |
PC_BUDGET_ITEM |
Character |
Conditional |
Project budget item. Prompts from the PC_BUD_ITM_VW table. This field is required if the analysis type provided for the transaction line is from the Budget analysis group that is specified at the installation level. |
28 |
BUDGET_LN |
Number |
Conditional |
Budget line number. This field is required if the analysis type provided for the transaction line is from the Budget analysis group that is specified at the installation level. |
29 |
PROJ_ROLE |
Character |
Optional |
Project role. Prompts from the PROJ_ROLE_SECVW table. |
30 |
KK_BUDG_LN_TYPE |
Character |
Conditional |
Budget line code. If Commitment Control is enabled, populate this field based on the translate values of the KK_BUDG_LN_TYPE field. |
31 |
BD_HDR_STATUS |
Character |
Optional |
Budget header status. The default value is N (the posting has not been run against the journal). |
32 |
GM_FA_SEQ_FLG |
Character |
Optional |
Fixed and administrative flag that is used by the PeopleSoft Grants system. |
33 |
GM_CS_SEQ_FLG |
Character |
Optional |
Cost sharing flag that is used by the PeopleSoft Grants system. |
34 |
FUND_SOURCE |
Character |
Optional |
Funding source. Prompts from the Funding Source table (KK_FUND_SOURCE). |
35 |
GM_DISTRIB_STATUS |
Character |
Optional |
Distribution status that is used by the PeopleSoft Grants system. |
36 |
PC_BUD_TYPE |
Character |
Optional |
If a budget type does not exist in the source file, the default value is cost budget. |
37 |
BUDGET_CATEGORY |
Character |
Conditional |
Budget item. Prompts from the Budget Category Control table (GM_BUD_CATEGORY). This field is required if the analysis type provided for the transaction line is from the Budget analysis group that is specified at the installation level. |
38 |
NUM_PERIODS |
Number |
Optional |
Number of time periods. |
39 |
ACT_UID |
Character |
Optional |
Task ID. |
40 |
RES_UID |
Character |
Optional |
Resource ID. |
41 |
PC_HOURS_PER_DAY |
Number |
Optional |
Hours per day. |
42 |
PC_FORECAST |
Number |
Optional |
Forecast units to load into Forecasting. |
43 |
PC_FORCAST_REMAIN |
Number |
Optional |
Remaining forecast units to load into Forecasting. |
44 |
STATUS_STRING |
Character |
Optional |
String text. |
45 |
START_DATE |
Date |
Optional |
Start date for Gen Stand. |
46 |
END_DATE |
Date |
Optional |
End date. |
47 |
LOAD_STATUS |
Character |
Optional |
Load status. |
48 |
CALENDAR_ID |
Character |
Conditional |
Calendar ID. This field is required if the analysis type provided for the transaction line is from the Budget analysis group that is specified at the installation level. |
49 |
ENTRY_EVENT |
Character |
Conditional |
Prompts from the EE_BUD_CODES_VW table. This field is required if Commitment Control and Projects Budgeting are enabled, and the analysis type provided for the transaction line is from the Budget analysis group that is specified at the installation level. |
50 |
KK_DEFAULT_EE |
Character |
Conditional |
Default entry event. This field is required if Commitment Control and Projects Budgeting are enabled, and the analysis type provided for the transaction line is from the Budget analysis group that is specified at the installation level. |
51 |
KK_GEN_PARENT |
Character |
Conditional |
Generate parent budget. This field is required if Commitment Control and Projects Budgeting are enabled, and the analysis type provided for the transaction line is from the Budget analysis group that is specified at the installation level. |
52 |
KK_PARENT_ENT_TYPE |
Character |
Conditional |
Parent budget entry type, such as original or adjustment. This field is required if Commitment Control and Projects Budgeting are enabled, and the analysis type provided for the transaction line is from the Budget analysis group that is specified at the installation level. |
53 |
KK_BUDG_TRANS_TYPE |
Character |
Conditional |
Budget entry type, such as original, adjustment, transfer, and so on. This field is required if Commitment Control and Projects Budgeting are enabled, and the analysis type provided for the transaction line is from the Budget analysis group that is specified at the installation level. |
54 |
PC_KK_AE_TYPE |
Character |
Conditional |
Commitment Control type, such as budget creation or budget check. This field is required if Commitment Control and Projects Budgeting are enabled, and the analysis type provided for the transaction line is from the Budget analysis group that is specified at the installation level. |
55 |
EE_PROC_STATUS |
Character |
Optional |
Entry Event line status. |