FO_PRJ_ACTIVITY

(SQL Table)
Index Back

Agreement Items

# PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description
1 BUSINESS_UNIT Character(5) VARCHAR2(5) NOT NULL Business Unit

Prompt Table: SP_BU_PC_NONVW

2 PROJECT_ID Character(15) VARCHAR2(15) NOT NULL Project Id ChartField

Prompt Table: PROJECT_VW

3 ACTIVITY_ID Character(15) VARCHAR2(15) NOT NULL Activity ID
4 DEPTID Character(10) VARCHAR2(10) NOT NULL Department

Prompt Table: FO_DEPT_VW

5 EMPLID Character(11) VARCHAR2(11) NOT NULL Employee ID
6 NATIONAL_ID Character(20) VARCHAR2(20) NOT NULL National ID
7 JOBCODE Character(6) VARCHAR2(6) NOT NULL Job Code

Prompt Table: FO_JOBCODE_VW

8 FO_CSF_ID Character(15) VARCHAR2(15) NOT NULL Definition ID
9 VENDOR_ID Character(10) VARCHAR2(10) NOT NULL Vendor Identifier

Prompt Table: FO_AVE_VND_S_VW

10 VNDR_LOC Character(10) VARCHAR2(10) NOT NULL Vendor Location

Prompt Table: VNDR_LOC_AP_VW

11 FO_MARKUP Character(4) VARCHAR2(4) NOT NULL Markup
NSTD=Non Standard Markup
STD=Standard Markup

Default Value: FO_PROJECT.FO_MARKUP

12 MARKUP_MULTIPLIER Signed Number(11,6) DECIMAL(9,6) NOT NULL Markup Multiplier
13 FO_STOT Character(1) VARCHAR2(1) NOT NULL Straight Time for Overtime

Y/N Table Edit

14 FO_STOT_APPROVAL Character(1) VARCHAR2(1) NOT NULL STOT Approval Flag

Y/N Table Edit

15 APPROVAL_OPRID Character(30) VARCHAR2(30) NOT NULL A system generated value that reflects the operator that approved a given transaction.
16 GP_PAYGROUP Character(10) VARCHAR2(10) NOT NULL Pay Group

Prompt Table: GP_PYGRP

17 PAYGROUP Character(3) VARCHAR2(3) NOT NULL Pay Group

Prompt Table: FO_PAYGROUP_VW2

18 WORKGROUP Character(10) VARCHAR2(10) NOT NULL Workgroup

Prompt Table: TL_WRKGRP_TBL

19 TASKGROUP Character(10) VARCHAR2(10) NOT NULL Taskgroup

Prompt Table: TL_TASKGRP_TBL

20 TAX_LOCATION_CD Character(10) VARCHAR2(10) NOT NULL Tax Location Code

Prompt Table: %EDITTABLE

21 LAST_MAINT_OPRID Character(30) VARCHAR2(30) NOT NULL Last Maintained By Operator ID
22 LAST_MAINT_DTTM DateTime(26) TIMESTAMP A system generated value that reflects the date and time a transaction was last modified
23 OPRID_ENTERED_BY Character(30) VARCHAR2(30) NOT NULL Entered By 07/25/2011 MRAD 12383033 :Ensured that OPRID_ENTERED_BY is set with format type of MixedCase. 03/22/2013 GL 16482301: Switched OPRID_ENTERED_BY back to MixedCase again. Please don't change it to UpperCase!!! FYI - The alternatives to use a User ID as uppercase: 1) Create your own User ID, add comments in the Field Properties, and fill out the Owner ID 2) Use %Upper meta-SQL in SQL statements 3) Use Upper function in peoplecodes
24 ADD_DTTM DateTime(26) TIMESTAMP Date Time Added
25 AWAITING_PO_FLG Character(1) VARCHAR2(1) NOT NULL Awaiting PO

Y/N Table Edit

26 PC_TEMPLATE_ID Character(15) VARCHAR2(15) NOT NULL Rate Template ID
27 FO_TEMP_TO_PERM Character(1) VARCHAR2(1) NOT NULL Permanent Hire

Y/N Table Edit

Default Value: N

28 CA_ALLOC_METHOD Character(1) VARCHAR2(1) NOT NULL Use Amount
1=Percent
2=Amount

Default Value: 1

29 CAREER_FEE Number(11,2) DECIMAL(10,2) NOT NULL Career Fee
30 CURRENCY_CD Character(3) VARCHAR2(3) NOT NULL Currency Code
31 FO_CAREER_NAME Character(50) VARCHAR2(50) NOT NULL Career Name
32 BUSINESS_UNIT_HR Character(5) VARCHAR2(5) NOT NULL Business Unit HR
33 COMPANY Character(3) VARCHAR2(3) NOT NULL Company

Prompt Table: COMPANY_TBL

34 TAX_CD Character(8) VARCHAR2(8) NOT NULL Tax Code

Prompt Table: CA_TAX_CD_VW