| # |
PeopleSoft Field Name |
PeopleSoft Field Type |
Database Column Type |
Description |
| 1 |
 COMMON_ID |
Character(11) |
VARCHAR2(11) NOT NULL |
Common ID to store Personal ID / Ext Org ID value
|
| 2 |
SA_ID_TYPE |
Character(1) |
VARCHAR2(1) NOT NULL |
ID Type
O=Organization
P=Person
|
| 3 |
SF_PROFILE_NBR |
Number(2,0) |
SMALLINT NOT NULL |
Account Profile
|
| 4 |
DESCR |
Character(30) |
VARCHAR2(30) NOT NULL |
Description
|
| 5 |
DESCRSHORT |
Character(10) |
VARCHAR2(10) NOT NULL |
Short Description
Default Value: SF_ACCT_PROFILE.DESCR
|
| 6 |
TENDER_CATEGORY |
Character(3) |
VARCHAR2(3) NOT NULL |
Tender Category
CC=Credit Card
CCI=Credit Card In
CCO=Credit Card Out
CK=Check
CKI=Check In
CKO=Check Out
CS=Cash
CSI=Cash In
CSO=Cash Out
DB=Debit Card
DBI=Debit Card In
DBO=Debit Card Out
DD=Direct Deposit
DDI=Direct Debit
DDO=Direct Deposit
EC=Electronic Check
TP=Third Party Check
TPI=Third Party Check In
WIR=Wire Transfer
Default Value: CC
Prompt Table:
TENDER_XLAT_VW
|
| 7 |
EMAIL_ADDR |
Character(70) |
VARCHAR2(70) NOT NULL |
Email Address
|
| 8 |
PHONE |
Character(24) |
VARCHAR2(24) NOT NULL |
Telephone
|
| 9 |
CR_CARD_EXPMO |
Character(2) |
VARCHAR2(2) NOT NULL |
Card Expiration Month
01=01
02=02
03=03
04=04
05=05
06=06
07=07
08=08
09=09
10=10
11=11
12=12
|
| 10 |
CR_CARD_EXPYR |
Character(4) |
VARCHAR2(4) NOT NULL |
Card Expiration Year
|
| 11 |
CR_CARD_FNAME |
Character(40) |
VARCHAR2(40) NOT NULL |
Credit Card First Name
|
| 12 |
CR_CARD_LNAME |
Character(40) |
VARCHAR2(40) NOT NULL |
Credit Card Last Name
|
| 13 |
CR_CARD_NBR |
Character(44) |
VARCHAR2(44) NOT NULL |
Credit Card Number
|
| 14 |
CR_CARD_TYPE |
Character(2) |
VARCHAR2(2) NOT NULL |
Credit Card Type
Prompt Table:
CR_CARD_TYPE_VW
|
| 15 |
BANK_ACCT_TYP |
Character(1) |
VARCHAR2(1) NOT NULL |
Bank Account Type
C=Checking
S=Savings
Default Value: C
|
| 16 |
BANK_CD |
Character(11) |
VARCHAR2(11) NOT NULL |
Bank ID
|
| 17 |
SSF_BNK_ACCT_NUM |
Character(44) |
VARCHAR2(44) NOT NULL |
Bank Account Number
|
| 18 |
PREF_ACCOUNT_FLAG |
Character(1) |
VARCHAR2(1) NOT NULL |
Preferred Account
Y/N Table Edit
Default Value: N
|