| ACTIVITY_ID |
Activity ID |
Example: 1 |
| KEY |
Type: character |
Format: Upper |
Length: 15 |
Decimals: 0 |
|
Activity is the unit of work in PS Projects that Provides a further breakdown of
projects, usually into specific tasks. Resources are assigned directly to Activities within a
Project. |
|
|
| |
| BUSINESS_UNIT |
Business Unit |
Example: UOD01 |
| KEY |
Type: character |
Format: Upper |
Length: 5 |
Decimals: 0 |
|
Business Unit |
|
|
| |
| BUSINESS_UNIT_PC |
PC Business Unit |
Example: UOD01 |
| KEY |
Type: character |
Format: Upper |
Length: 5 |
Decimals: 0 |
|
Business Unit (Always = UOD01) |
|
|
| |
| CONTRACT_LINE_NUM |
Contract Line Num |
Example: 1 |
| KEY |
Type: number |
Format: Upper |
Length: 3 |
Decimals: 0 |
|
Line number within the contract |
|
|
| |
| CONTRACT_NUM |
Contract |
Example: SES-0422772 |
| KEY |
Type: character |
Format: Mixed |
Length: 25 |
Decimals: 0 |
|
Unique identifier of a single contract. Same as "reference award number".
Assigned at the point that the contract is awarded. |
|
|
| |
| DEPTID |
Department |
Example: 02710 |
| KEY |
Type: character |
Format: Upper |
Length: 10 |
Decimals: 0 |
|
Identifies the administrative budget unit controling one or more Purposes. Some
entries are not actual departments, but are merely nodes on a tree that organizes departments
into a hierarchy for reporting purposes. |
|
|
| |
| FA_RATE_TYPE |
Facilities Admin Rate |
Example: RSONF |
| KEY |
Type: character |
Format: Upper |
Length: 5 |
Decimals: 0 |
|
F&A Rate Type, such as Animal Care, On Campus, Off Campus, Institutional
Research, or Instruction |
|
|
| |
| PROJECT_ID |
Project |
Example: BUAD31211105000 |
| KEY |
Type: character |
Format: Upper |
Length: 15 |
Decimals: 0 |
|
Chartfield which identifies contract and grant activities and facilities projects
(eg. ARTC37211199000). Adds designators to a "Purpose" (eg. ARTC372111) indicating fiscal year,
building, or other coded details. |
|
|
| |
| RATE_EFFDT |
Rate Effective Date |
Example: 7/1/2003 |
| KEY |
Type: date |
Format: Upper |
Length: 10 |
Decimals: 0 |
|
Effecive Date of IDC rate period one |
|
|
| |
| ACTIVITY_FLAG |
Use all activities |
Example: ONE |
|
Type: character |
Format: Mixed |
Length: 3 |
Decimals: 0 |
|
Number of activities included in the project |
|
|
| |
| AFUDC_PROJ_SW |
Allow Interest Calculation |
Example: N |
|
Type: character |
Format: Upper |
Length: 1 |
Decimals: 0 |
|
Select if interest should calculate on the balance. |
|
|
| |
| AN_GRP_ACTV_BUD |
Budget Analysis Group |
Example: GBUD |
|
Type: character |
Format: Upper |
Length: 5 |
Decimals: 0 |
|
Budget related analysis types grouped together |
|
|
| |
| AN_GRP_TOT_COSTS |
Cost Analysis Group |
Example: ACT |
|
Type: character |
Format: Upper |
Length: 5 |
Decimals: 0 |
|
Cost related analysis types grouped together |
|
|
| |
| BILLED_TO_DATE |
Billed To Date |
Example: 0 |
|
Type: signed number |
Format: Upper |
Length: 28 |
Decimals: 3 |
|
Amount billed to date on the project |
|
|
| BUSINESS_UNIT_AM |
Asset Management Business Unit |
Example: UOD01 |
|
Type: character |
Format: Upper |
Length: 5 |
Decimals: 0 |
|
Business Unit (Always = UOD01) |
|
|
| |
| CUR_EFFDT_TYPE |
Currency Eff. Date Default |
Example: A |
|
Type: character |
Format: Upper |
Length: 1 |
Decimals: 0 |
|
If you want to set the Currency Effective Date on the journal header to be the
ADB Date, select ADB Date on the template. Otherwise, the default is the journal date. |
|
|
| |
| CURRENCY_CD |
Currency Code |
Example: USD |
|
Type: character |
Format: Upper |
Length: 3 |
Decimals: 0 |
|
Currency Code |
|
|
| |
| DESCR |
Description |
Example: NSF KNOWLEDGE |
|
Type: character |
Format: Mixed |
Length: 30 |
Decimals: 0 |
|
Description |
|
|
| |
| DTTM_STAMP |
Date/Time Stamp |
Example: 08/06/2004 2:40:48PM |
|
Type: date-time |
Format: Seconds |
Length: 26 |
Decimals: 0 |
|
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. |
|
|
| |
| EFF_STATUS |
Status as of Effective Date |
Example: A |
|
Type: character |
Format: Upper |
Length: 1 |
Decimals: 0 |
|
Effective Status |
|
|
| |
| EMPLID |
EmplID |
Example: |
|
Type: character |
Format: Upper |
Length: 11 |
Decimals: 0 |
|
Employee ID |
|
|
| |
| ENFORCE |
Enforce Project Team |
Example: N |
|
Type: character |
Format: Upper |
Length: 1 |
Decimals: 0 |
|
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. |
|
|
| |
| ENFORCE_TYPE |
Enforce type |
Example: N |
|
Type: character |
Format: Upper |
Length: 1 |
Decimals: 0 |
|
Enforce project and activity team based prompt. |
|
|
| |
| FA_BASE_ID |
FA Base ID |
Example: MTDC |
|
Type: character |
Format: Upper |
Length: 5 |
Decimals: 0 |
|
Facilities and Administration Base |
|
|
| |
| FA_FUNDED_RATE_PCT |
FA Funded Rate % |
Example: 51 |
|
Type: number |
Format: Upper |
Length: 6 |
Decimals: 2 |
|
F&A funded rate percentage |
|
|
| |
| FA_INST_BASE_ID |
Institution Base |
Example: MTDC |
|
Type: character |
Format: Upper |
Length: 5 |
Decimals: 0 |
|
F&A Institutional Base ID |
|
|
| |
| FA_INST_RATE_PCT |
FA Institution Rate % |
Example: 51 |
|
Type: number |
Format: Upper |
Length: 6 |
Decimals: 2 |
|
Institutional Rate for F&A |
|
|
| |
| FA_SPNSR_BASE_ID |
Sponsor Base |
Example: MTDC |
|
Type: character |
Format: Upper |
Length: 5 |
Decimals: 0 |
|
Basis on which the F&A (facilities & administration) rate is determined. Values
include: MTDC=Modified Total Direct Cost; SLNWG=Salary & wages; FXTDC=Fixed total direct cost;
NOFA=No F&A; BRTOL=Bartol (old grants); REU=Research expense for undergraduate. |
|
|
| FA_SPNSR_RATE_PCT |
FA Sponsor Rate % |
Example: 51 |
|
Type: number |
Format: Upper |
Length: 6 |
Decimals: 2 |
|
F&A Sponsor Rate |
|
|
| |
| GM_PRIMARY_FLAG |
Project Primary Flag |
Example: Y |
|
Type: character |
Format: Upper |
Length: 1 |
Decimals: 0 |
|
This field is used to indicate a Project as a Primary Project |
|
|
| |
| GRANT_FLG |
Grants Project |
Example: Y |
|
Type: character |
Format: Upper |
Length: 1 |
Decimals: 0 |
|
Grants Management Used for designating whether or not an object is for Grants or
for Projects. |
|
|
| |
| IN_USE_SW |
Table in use switch |
Example: N |
|
Type: character |
Format: Upper |
Length: 1 |
Decimals: 0 |
|
Should always default to N |
|
|
| |
| INSTID |
Institution ID |
Example: UOD01 |
|
Type: character |
Format: Upper |
Length: 5 |
Decimals: 0 |
|
Always=UOD01 |
|
|
| |
| LAST_ACTIVITY_ID |
Last Actvity ID |
Example: 0 |
|
Type: number |
Format: Upper |
Length: 8 |
Decimals: 0 |
|
Last Activity ID Created |
|
|
| |
| LAST_CRITERIA_ID |
Last Criteria ID |
Example: 0 |
|
Type: number |
Format: Upper |
Length: 8 |
Decimals: 0 |
|
Last Criteria ID created |
|
|
| |
| MAJOR_SUBDIVISION |
Major Subdivision ID |
Example: 02701 |
|
Type: character |
Format: Upper |
Length: 10 |
Decimals: 0 |
|
Department-ID associated with each project. |
|
|
| |
| PC_ACT_OPTION |
Standard Activities |
Example: F |
|
Type: character |
Format: Upper |
Length: 1 |
Decimals: 0 |
|
To enable standard activity functionality, check the Standard Activity box on the
Projects General - Definition page |
|
|
| |
| PC_FND_DIST_SW |
Multiple Funding Sources? |
Example: N |
|
Type: character |
Format: Upper |
Length: 1 |
Decimals: 0 |
|
This field is used to indicate the use of Funds Distribution
functionality. |
|
|
| |
| PC_REV_ACTIVITY |
Revenue Activity |
Example: 1 |
|
Type: character |
Format: Upper |
Length: 15 |
Decimals: 0 |
|
Revenue Activity Product Code |
|
|
| |
| PC_TEMPLATE_ID |
Rate Template ID |
Example: GMRT1 |
|
Type: character |
Format: Upper |
Length: 5 |
Decimals: 0 |
|
Identifies the rate template for a given business unit |
|
|
| |
| PERCENT_COMPLETE |
% Complete |
Example: 0 |
|
Type: number |
Format: Upper |
Length: 6 |
Decimals: 2 |
|
Completion Percentage of Project |
|
|
| |
| PROJ_GRANT_STATUS |
Status |
Example: I |
|
Type: character |
Format: Upper |
Length: 1 |
Decimals: 0 |
|
Active or Inactive |
|
|
| |
| PROJECT_TYPE |
Project Type |
Example: FEDRL |
|
Type: character |
Format: Upper |
Length: 5 |
Decimals: 0 |
|
Indicates type of project,fedrl grant, state grant, build.. |
|
|
| |
| PROJECT_USERAMT1 |
Amount 1 |
Example: 0 |
|
Type: signed number |
Format: Upper |
Length: 17 |
Decimals: 2 |
|
User defined Field |
|
|
| |
| PROJECT_USERAMT2 |
Amount 2 |
Example: 0 |
|
Type: signed number |
Format: Upper |
Length: 17 |
Decimals: 2 |
|
User defined Field |
|
|
| |
| PROJECT_USERAMT3 |
Amount 3 |
Example: 0 |
|
Type: signed number |
Format: Upper |
Length: 17 |
Decimals: 2 |
|
User defined Field |
|
|
| |
| RATE_EFFDT2 |
Rate Effective Date |
Example: 7/1/2003 |
|
Type: date |
Format: Upper |
Length: 10 |
Decimals: 0 |
|
Effecive Date of IDC rate period two |
|
|
| |
| RATE_EFFDT3 |
Rate Effective Date |
Example: 7/1/2004 |
|
Type: date |
Format: Upper |
Length: 10 |
Decimals: 0 |
|
Effecive Date of IDC rate period three |
|
|
| |
| RESOURCE_CATEGORY |
Resource Category |
Example: |
|
Type: character |
Format: Upper |
Length: 5 |
Decimals: 0 |
|
Resource Categories associated with the given resource type; multiple resource
categories can be related to a single resource type. |
|
|
| RESOURCE_SUB_CAT |
Resource SubCategory |
Example: |
|
Type: character |
Format: Upper |
Length: 5 |
Decimals: 0 |
|
Subcategory associated with given resource category.Multiple subcategories can be
related to a single resource category. |
|
|
| |
| RESOURCE_TYPE |
Resource Type |
Example: |
|
Type: character |
Format: Upper |
Length: 5 |
Decimals: 0 |
|
Type of resource can be categorized in categories and subcategories for
analysis |
|
|
| |
| RT_TYPE |
Rate Type |
Example: CRRNT |
|
Type: character |
Format: Upper |
Length: 5 |
Decimals: 0 |
|
Defines a category of market rates for currency conversion. Some examples of rate
types are commercial, average, floating, and historical. |
|
|
| |
| SALES_TAX_PROJ_SW |
Allow Sales Tax Calculation |
Example: N |
|
Type: character |
Format: Upper |
Length: 1 |
Decimals: 0 |
|
Select if calculating sales tax |
|
|
| |
| SET_OVERRIDE |
FS_08 SetID |
Example: UOD01 |
|
Type: character |
Format: Upper |
Length: 5 |
Decimals: 0 |
|
Always UOD01 |
|
|
| |
| SUMMARY_SW |
Allow activities on this node |
Example: Y |
|
Type: character |
Format: Upper |
Length: 1 |
Decimals: 0 |
|
Select if activities allowed on this node |
|
|
| |
| SYSTEM_SOURCE |
System Source |
Example: PPC |
|
Type: character |
Format: Upper |
Length: 3 |
Decimals: 0 |
|
Identifies the application or source system that generated a journal
entry. |
|
|
| |
| TARGET_PROJ_SW |
Allocation Target |
Example: N |
|
Type: character |
Format: Upper |
Length: 1 |
Decimals: 0 |
|
Select if this node should be used for project allocation |
|
|
| |
| TEMPLATE_SW |
Can be used as Template |
Example: N |
|
Type: character |
Format: Upper |
Length: 1 |
Decimals: 0 |
|
Allows the user to indicate whether a given bank transfer transaction should be
designated as a |
|
|
| |
| TOLERANCE |
Tolerance Percent |
Example: 0 |
|
Type: signed number |
Format: Upper |
Length: 13 |
Decimals: 8 |
|
The tolerance percent is the percent a project can go over budget before
commitment control creates an exception |
|
|
| |