PV_USBANKTYPE2

#	PeopleSoft Field Name	PeopleSoft Field Type	Database Column Type	Description
1	SBTTYPE2	Character(1)	VARCHAR2(1) NOT NULL	RECORD TYPE ID
2	SBTACCT	Character(16)	VARCHAR2(16) NOT NULL	ACCOUNT NUMBER
3	SBTNLIN1	Character(25)	VARCHAR2(25) NOT NULL	NAME LINE-1
4	SBTSOSEC	Character(9)	VARCHAR2(9) NOT NULL	SOCIAL SECURITY NUMBER
5	SNTPLEMP	Character(15)	VARCHAR2(15) NOT NULL	PLACE OF EMPLOYMENT
6	SBTALIN2	Long Character(35)	VARCHAR2(35)	ADDRESS LINE-2
7	SBTSPOUS	Character(15)	VARCHAR2(15) NOT NULL	SPOUSE
8	SBTUACCT1	Character(14)	VARCHAR2(14) NOT NULL	USER ACCT-1
9	SBTUACCT2	Character(14)	VARCHAR2(14) NOT NULL	USER ACCT-2
10	SBTUACCT3	Character(14)	VARCHAR2(14) NOT NULL	USER ACCT-3
11	SBTUCOD3	Character(4)	VARCHAR2(4) NOT NULL	USER DATA-3
12	SBTPYDD	Character(6)	VARCHAR2(6) NOT NULL	PAYMENT DUE DATE
13	SBTDBORN	Character(4)	VARCHAR2(4) NOT NULL	DATE OF BIRTH
14	SBTCRATE	Character(2)	VARCHAR2(2) NOT NULL	CREDIT RATING
15	SBTALIN1	Character(36)	VARCHAR2(36) NOT NULL	SBTALIN1
16	SBTCITY	Character(25)	VARCHAR2(25) NOT NULL	CITY
17	SBTSTATE	Character(2)	VARCHAR2(2) NOT NULL	STATE
18	SBTZIP	Character(9)	VARCHAR2(9) NOT NULL	ZIP CODE
19	SBTWPHON	Character(10)	VARCHAR2(10) NOT NULL	WORK PHONE
20	SBTACTS	Character(1)	VARCHAR2(1) NOT NULL	CTS ACCOUNT INDICATOR
21	SBTLEVEL	Character(35)	VARCHAR2(35) NOT NULL	TBR HIERARCHY REPORTING UNIT
22	SBTGRP1	Character(5)	VARCHAR2(5) NOT NULL	TBR REPORTING GROUP 1
23	SBTGRP2	Character(5)	VARCHAR2(5) NOT NULL	TBR REPORTING GROUP 2
24	SBTGRP3	Character(5)	VARCHAR2(5) NOT NULL	TBR REPORTING GROUP3
25	SBTHOLD	Character(3)	VARCHAR2(3) NOT NULL	CODE FOR HOLDING STATEMENT
26	SBTBCYCL	Character(2)	VARCHAR2(2) NOT NULL	CYCLE DATE
27	SBTEXPIR	Character(4)	VARCHAR2(4) NOT NULL	ACCOUNT EXPIRATION DATE
28	SBTCORP	Character(1)	VARCHAR2(1) NOT NULL	CORPORATE ACCOUNT FLAG
29	SBTUCOD2	Character(4)	VARCHAR2(4) NOT NULL	LIABILITY CODES
30	SBTY2LL	Character(34)	VARCHAR2(34) NOT NULL	FILLER