RS_2015RPT_TBL2

(SQL Table)
Index Back

# PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description
1 OPRID Character(30) VARCHAR2(30) NOT NULL A user's ID (see PSOPRDEFN).
2 START_DT Date(10) DATE Start Date
3 END_DT Date(10) DATE End Date
4 DEPTNAME Character(30) VARCHAR2(30) NOT NULL Department
5 BUSINESS_UNIT Character(5) VARCHAR2(5) NOT NULL Business Unit
6 NAME1 Character(40) VARCHAR2(40) NOT NULL Name 1
7 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.
8 ADDRESS1 Character(55) VARCHAR2(55) NOT NULL Address 1
9 CITY Character(30) VARCHAR2(30) NOT NULL City
10 STATE Character(6) VARCHAR2(6) NOT NULL State
11 POSTAL Character(12) VARCHAR2(12) NOT NULL Postal
12 COUNTRY Character(3) VARCHAR2(3) NOT NULL Country
13 PHONE Character(24) VARCHAR2(24) NOT NULL Telephone
14 PROJECT_ID Character(15) VARCHAR2(15) NOT NULL Project Id ChartField
15 NAME Character(50) VARCHAR2(50) NOT NULL Name
16 EMPLID Character(11) VARCHAR2(11) NOT NULL Employee ID
17 ASSIGNMENT_ID Character(15) VARCHAR2(15) NOT NULL Work Assignment ID
18 SO_ID Character(15) VARCHAR2(15) NOT NULL Service Order ID
19 SO_LINE Number(3,0) SMALLINT NOT NULL Line Number
20 TASK_TYPE Character(18) VARCHAR2(18) NOT NULL Task Category
21 START_DT_2 Date(10) DATE Start Date
22 END_DT_2 Date(10) DATE End Date
23 LASTUPDDTTM DateTime(26) TIMESTAMP 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.