PROJ_ACT_LOC

(SQL Table)
Index Back

Project Activity Location

Project Activity Location

# 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: PROJ_SCRTY_SRCH

3 ACTIVITY_ID Character(15) VARCHAR2(15) NOT NULL Activity ID
4 EFFDT Date(10) DATE NOT NULL Effective Date

Default Value: %date

5 EFFSEQ Number(3,0) SMALLINT NOT NULL Effective Sequence

Default Value: 1

6 LOCATION Character(10) VARCHAR2(10) NOT NULL Location Code

Default Value: LOCATION_TBL.LOCATION

Prompt Table: LOCATION_TBL

7 LOCATION_FRACTION Number(4,2) DECIMAL(3,2) NOT NULL Fraction of Cost at Location

Default Value: 1

8 CUST_ID Character(15) VARCHAR2(15) NOT NULL Uniquely identifies an organizational entity that purchases goods or services from the enterprise. Represents the sold-to customer which is the customer organization that places orders. The CUST_ID may or may not be the same as the identifiers for the bill-to and ship-to locations.

Prompt Table: PROJ_CUST_VW

9 COUNTRY Character(3) VARCHAR2(3) NOT NULL Country

Prompt Table: COUNTRY_TBL

10 ADDRESS1 Character(55) VARCHAR2(55) NOT NULL Address 1
11 ADDRESS2 Character(55) VARCHAR2(55) NOT NULL Address 2
12 ADDRESS3 Character(55) VARCHAR2(55) NOT NULL Address 3
13 ADDRESS4 Character(55) VARCHAR2(55) NOT NULL Address 4
14 CITY Character(30) VARCHAR2(30) NOT NULL City
15 NUM1 Character(6) VARCHAR2(6) NOT NULL Number 1
16 NUM2 Character(6) VARCHAR2(6) NOT NULL Number 2
17 HOUSE_TYPE Character(2) VARCHAR2(2) NOT NULL House Type
AB=House Boat
WW=Trailer
18 ADDR_FIELD1 Character(2) VARCHAR2(2) NOT NULL Address Field 1
19 ADDR_FIELD2 Character(4) VARCHAR2(4) NOT NULL Address Field 2
20 ADDR_FIELD3 Character(4) VARCHAR2(4) NOT NULL Address Field 3
21 COUNTY Character(30) VARCHAR2(30) NOT NULL County
22 STATE Character(6) VARCHAR2(6) NOT NULL State

Prompt Table: %EDIT_STATE

23 POSTAL Character(12) VARCHAR2(12) NOT NULL Postal
24 GEO_CODE Character(11) VARCHAR2(11) NOT NULL Geo Code
25 IN_CITY_LIMIT Character(1) VARCHAR2(1) NOT NULL In City Limit

Y/N Table Edit