| # |
PeopleSoft Field Name |
PeopleSoft Field Type |
Database Column Type |
Description |
| 1 |
 SETID |
Character(5) |
VARCHAR2(5) NOT NULL |
SetID
Prompt Table:
SP_SETID_NONVW
|
| 2 |
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:
CUSTOMER
|
| 3 |
AGENCY_DEBTOR_ID |
Character(15) |
VARCHAR2(15) NOT NULL |
Agency Debtor ID
|
| 4 |
DEBTOR_TYPE |
Character(3) |
VARCHAR2(3) NOT NULL |
DMS Debtor Type
COR=Corporation
IND=Individual
JTV=Joint Venture
OTH=Other
PAR=Partnership
SLG=State/Local Government
SPR=Sole Proprietorship
Default Value: COR
|
| 5 |
GENDER |
Character(1) |
VARCHAR2(1) NOT NULL |
Gender
F=Female
M=Male
U=Unknown
Default Value: U
|
| 6 |
FED_CIVILIAN_EMP |
Character(1) |
VARCHAR2(1) NOT NULL |
Federal Civilian Emp
A=Active
N=Neither
R=Retired
|
| 7 |
FED_MILITARY_EMP |
Character(1) |
VARCHAR2(1) NOT NULL |
Federal Military Emp
A=Active
N=Neither
R=Retired
|
| 8 |
ATTORNEY_NAME |
Character(30) |
VARCHAR2(30) NOT NULL |
Attorney Name
|
| 9 |
FIRST_NAME |
Character(30) |
VARCHAR2(30) NOT NULL |
First Name
|
| 10 |
MIDDLE_INITIAL |
Character(1) |
VARCHAR2(1) NOT NULL |
Middle Initial
|
| 11 |
LAST_NAME |
Character(30) |
VARCHAR2(30) NOT NULL |
Last Name
|
| 12 |
GENERATION_VALUE |
Character(3) |
VARCHAR2(3) NOT NULL |
Generation
I=I
II=II
III=III
IV=IV
JR=JR.
SR=SR.
V=V
|
| 13 |
BIRTH_DATE |
Date(10) |
DATE |
Cart Birth Date
|
| 14 |
ALIAS_TYPE |
Character(3) |
VARCHAR2(3) NOT NULL |
Alias Type
AKA=Also known as
DBA=Doing Business As
FKA=Formerly Known As
|
| 15 |
ALIAS_FIRST_NAME |
Character(15) |
VARCHAR2(15) NOT NULL |
Alias First Name
|
| 16 |
ALIAS_MIDDLE_INIT |
Character(1) |
VARCHAR2(1) NOT NULL |
Alias Middle Initial
|
| 17 |
ALIAS_LAST_NAME |
Character(30) |
VARCHAR2(30) NOT NULL |
Alias Last Name
|
| 18 |
ALIAS_GENERATION |
Character(3) |
VARCHAR2(3) NOT NULL |
Alias Generation
I=I
II=II
III=III
IV=IV
JR=JR.
SR=SR.
V=V
|
| 19 |
PROPERTY_TYPE |
Character(1) |
VARCHAR2(1) NOT NULL |
Property Type
P=Personal
R=Non-Residential Real
S=Residential Real
|
| 20 |
PROPERTY |
Character(35) |
VARCHAR2(35) NOT NULL |
Property Name
|
| 21 |
EMPLOYER |
Character(30) |
VARCHAR2(30) NOT NULL |
Employer
|
| 22 |
EMPLOYER_ADDR1 |
Character(30) |
VARCHAR2(30) NOT NULL |
Employer Address Line 1
|
| 23 |
EMPLOYER_ADDR2 |
Character(30) |
VARCHAR2(30) NOT NULL |
Employer Address Line 2
|
| 24 |
EMPLOYER_CITY |
Character(15) |
VARCHAR2(15) NOT NULL |
Employer City
|
| 25 |
EMPLOYER_STATE |
Character(2) |
VARCHAR2(2) NOT NULL |
Employer State
Prompt Table:
STATE_TBL_US_VW
|
| 26 |
EMPLOYER_ZIP |
Character(5) |
VARCHAR2(5) NOT NULL |
Employer Zip Code
|
| 27 |
EMPLOYER_ZIP_EXT |
Character(4) |
VARCHAR2(4) NOT NULL |
Employer Zip Code Extension
|
| 28 |
EMPLYMNT_AREA_CODE |
Character(3) |
VARCHAR2(3) NOT NULL |
Employment Area Code
|
| 29 |
EMPLYMNT_NUMBER |
Number(7,0) |
INTEGER NOT NULL |
Employment Phone Number
|
| 30 |
EMPLYMNT_PHONE_EXT |
Character(4) |
VARCHAR2(4) NOT NULL |
Employment Phone Extension
|
| 31 |
JOB_TITLE20 |
Character(20) |
VARCHAR2(20) NOT NULL |
Job Title
|
| 32 |
SALARY_AMT |
Signed Number(15,2) |
DECIMAL(13,2) NOT NULL |
Salary
|
| 33 |
SALARY_CYCLE |
Character(1) |
VARCHAR2(1) NOT NULL |
Salary Cycle
A=Annually
B=BI-Weeky
M=Monthly
O=Other
W=Weekly
|
| 34 |
GROSS_OR_NET |
Character(1) |
VARCHAR2(1) NOT NULL |
Gross or Net
G=Gross
N=Net
|
| 35 |
TAXPAYER_ID_TYPE |
Character(3) |
VARCHAR2(3) NOT NULL |
TIN Type
EIN=Employer Identification Number
SSN=Social Security Number
Default Value: EIN
|
| 36 |
DATE_OF_INCORP |
Date(10) |
DATE |
Date of Incorporation
|
| 37 |
STATE_OF_INCORP |
Character(2) |
VARCHAR2(2) NOT NULL |
State of Incorporation
Prompt Table:
STATE_TBL_US_VW
|
| 38 |
CONTACT_NAME |
Character(50) |
VARCHAR2(50) NOT NULL |
The individual contact name associated with a given bank/counterparty.
|
| 39 |
AGENT_NAME |
Character(40) |
VARCHAR2(40) NOT NULL |
Agent Name
|
| 40 |
DUNS_NUMBER |
Character(9) |
VARCHAR2(9) NOT NULL |
DUNS Number
|
| 41 |
ALIAS_BUSINESSNAME |
Character(40) |
VARCHAR2(40) NOT NULL |
Alias Business Name
|
| 42 |
DESCR |
Character(30) |
VARCHAR2(30) NOT NULL |
Description
|
| 43 |
BANK_ADDRESS1 |
Character(35) |
VARCHAR2(35) NOT NULL |
Bank Address1
|
| 44 |
BANK_ADDRESS2 |
Character(35) |
VARCHAR2(35) NOT NULL |
Bank Address2
|
| 45 |
BANK_CITY |
Character(15) |
VARCHAR2(15) NOT NULL |
City
|
| 46 |
BANK_STATE |
Character(2) |
VARCHAR2(2) NOT NULL |
State
Prompt Table:
STATE_TBL_US_VW
|
| 47 |
BANK_ZIP |
Character(5) |
VARCHAR2(5) NOT NULL |
Postal Code
|
| 48 |
BANK_ZIP_CODE_EXT |
Character(4) |
VARCHAR2(4) NOT NULL |
Zip Code/Ext
|
| 49 |
DMS_ACCOUNT_NUM1 |
Character(16) |
VARCHAR2(16) NOT NULL |
1st Account Number
|
| 50 |
DMS_ACCOUNT_TYPE1 |
Character(3) |
VARCHAR2(3) NOT NULL |
1st Account Type
CK1=Primary Checking
MM1=Money Market
SV1=Primary Savings
|
| 51 |
DMS_ACCOUNT_NUM2 |
Character(16) |
VARCHAR2(16) NOT NULL |
2nd Account Number
|
| 52 |
DMS_ACCOUNT_TYPE2 |
Character(3) |
VARCHAR2(3) NOT NULL |
2nd Account Type
CK1=Primary Checking
MM1=Money Market
SV1=Primary Savings
|
| 53 |
DMS_ACCOUNT_NUM3 |
Character(16) |
VARCHAR2(16) NOT NULL |
3rd Account Number
|
| 54 |
DMS_ACCOUNT_TYPE3 |
Character(3) |
VARCHAR2(3) NOT NULL |
3rd Account Type
CK1=Primary Checking
MM1=Money Market
SV1=Primary Savings
|