| # |
PeopleSoft Field Name |
PeopleSoft Field Type |
Database Column Type |
Description |
| 1 |
 COUNTRY |
Character(3) |
VARCHAR2(3) NOT NULL |
Country
Prompt Table:
COUNTRY_TBL
|
| 2 |
EXCHNG_TO_CURRENCY |
Character(3) |
VARCHAR2(3) NOT NULL |
To Currency
Default Value: USD
Prompt Table:
CURRENCY_CD_TBL
|
| 3 |
EXCHNG_TO_RT_TYPE |
Character(5) |
VARCHAR2(5) NOT NULL |
Currency Rate Type
Prompt Table:
CUR_RT_TYPE_TBL
|
| 4 |
AP |
Character(1) |
VARCHAR2(1) NOT NULL |
Payables
Y/N Table Edit
Default Value: Y
|
| 5 |
AR |
Character(1) |
VARCHAR2(1) NOT NULL |
Receivables
Y/N Table Edit
Default Value: Y
|
| 6 |
AM |
Character(1) |
VARCHAR2(1) NOT NULL |
Asset Management
Y/N Table Edit
Default Value: Y
|
| 7 |
BI |
Character(1) |
VARCHAR2(1) NOT NULL |
Billing
Y/N Table Edit
Default Value: Y
|
| 8 |
BD |
Character(1) |
VARCHAR2(1) NOT NULL |
Budgets
Y/N Table Edit
Default Value: Y
|
| 9 |
DM |
Character(1) |
VARCHAR2(1) NOT NULL |
DM Product
Y/N Table Edit
Default Value: N
|
| 10 |
EP |
Character(1) |
VARCHAR2(1) NOT NULL |
Enterprise Planning
Y/N Table Edit
Default Value: N
|
| 11 |
PL |
Character(1) |
VARCHAR2(1) NOT NULL |
Production Planning
Y/N Table Edit
Default Value: Y
|
| 12 |
CP |
Character(1) |
VARCHAR2(1) NOT NULL |
Product Configuration Field
Y/N Table Edit
Default Value: N
|
| 13 |
GL |
Character(1) |
VARCHAR2(1) NOT NULL |
General Ledger
Y/N Table Edit
Default Value: Y
|
| 14 |
INV |
Character(1) |
VARCHAR2(1) NOT NULL |
Inventory
Y/N Table Edit
Default Value: Y
|
| 15 |
OM |
Character(1) |
VARCHAR2(1) NOT NULL |
Order Management
Y/N Table Edit
Default Value: Y
|
| 16 |
PC |
Character(1) |
VARCHAR2(1) NOT NULL |
Projects
Y/N Table Edit
Default Value: Y
|
| 17 |
PO |
Character(1) |
VARCHAR2(1) NOT NULL |
Purchasing
Y/N Table Edit
Default Value: Y
|
| 18 |
MG |
Character(1) |
VARCHAR2(1) NOT NULL |
Manufacturing
Y/N Table Edit
Default Value: Y
|
| 19 |
TR |
Character(1) |
VARCHAR2(1) NOT NULL |
Treasury
Y/N Table Edit
Default Value: N
|
| 20 |
EG |
Character(1) |
VARCHAR2(1) NOT NULL |
Engineering
Y/N Table Edit
Default Value: Y
|
| 21 |
EX |
Character(1) |
VARCHAR2(1) NOT NULL |
Expenses
Y/N Table Edit
Default Value: Y
|
| 22 |
QS |
Character(1) |
VARCHAR2(1) NOT NULL |
Quality
Y/N Table Edit
Default Value: Y
|
| 23 |
DP |
Character(1) |
VARCHAR2(1) NOT NULL |
Demantra
Y/N Table Edit
Default Value: Y
|
| 24 |
HR |
Character(1) |
VARCHAR2(1) NOT NULL |
Human Capital Management
Default Value: N
|
| 25 |
FO |
Character(1) |
VARCHAR2(1) NOT NULL |
Staffing Front Office
Default Value: Y
|
| 26 |
RP |
Character(1) |
VARCHAR2(1) NOT NULL |
Resume Processing
Default Value: Y
|
| 27 |
PB |
Character(1) |
VARCHAR2(1) NOT NULL |
Pay/Bill Management
Default Value: N
|
| 28 |
PUBLIC_SECTOR |
Character(1) |
VARCHAR2(1) NOT NULL |
Public Sector
Y/N Table Edit
Default Value: N
|
| 29 |
ADDRESS_VENDOR |
Character(1) |
VARCHAR2(1) NOT NULL |
Address Supplier
N=None
U=USA Unzipped
Default Value: N
|
| 30 |
TAX_VENDOR |
Character(1) |
VARCHAR2(1) NOT NULL |
Tax Provider
A=Taxware
N=None
V=Vertex
Default Value: N
|
| 31 |
JETFORMS |
Character(1) |
VARCHAR2(1) NOT NULL |
JetForms Installed
Y/N Table Edit
Default Value: N
|
| 32 |
DC_INSTALLED |
Character(1) |
VARCHAR2(1) NOT NULL |
Document Management
Y/N Table Edit
Default Value: N
|
| 33 |
MULTIBOOK_FLAG |
Character(1) |
VARCHAR2(1) NOT NULL |
Multibook entries in Subsystem
Y/N Table Edit
Default Value: N
|
| 34 |
ALTACCT_OPTN |
Character(1) |
VARCHAR2(1) NOT NULL |
Enable Alternate Account
Default Value: N
|
| 35 |
COMMITMENT_CNTL_AP |
Character(1) |
VARCHAR2(1) NOT NULL |
Commitment Control on AP
Y/N Table Edit
Default Value: N
|
| 36 |
COMMITMENT_CNTL_AR |
Character(1) |
VARCHAR2(1) NOT NULL |
Commitment Control on AR
Y/N Table Edit
Default Value: N
|
| 37 |
COMMITMENT_CNTL_BI |
Character(1) |
VARCHAR2(1) NOT NULL |
Commitment Control on BI
Y/N Table Edit
Default Value: N
|
| 38 |
COMMITMENT_CNTL_EX |
Character(1) |
VARCHAR2(1) NOT NULL |
Commitment Control on EX
Y/N Table Edit
Default Value: N
|
| 39 |
COMMITMENT_CNTL_GL |
Character(1) |
VARCHAR2(1) NOT NULL |
Commitment Control on GL
Y/N Table Edit
Default Value: N
|
| 40 |
COMMITMENT_CNTL_IN |
Character(1) |
VARCHAR2(1) NOT NULL |
Commitment Control on IN
Y/N Table Edit
Default Value: N
|
| 41 |
COMMITMENT_CNTL_PC |
Character(1) |
VARCHAR2(1) NOT NULL |
Commitment Control on PC
Y/N Table Edit
Default Value: N
|
| 42 |
COMMITMENT_CNTL_PO |
Character(1) |
VARCHAR2(1) NOT NULL |
Commitment Control on PO
Y/N Table Edit
Default Value: N
|
| 43 |
PROC_PART_GL |
Character(1) |
VARCHAR2(1) NOT NULL |
Process Partition for GL
Y/N Table Edit
Default Value: Y
|
| 44 |
EMPLID_LAST_EMPL |
Number(10,0) |
DECIMAL(10) NOT NULL |
Last Employee ID Assigned
|
| 45 |
FO_FREQUENCY |
Character(10) |
VARCHAR2(10) NOT NULL |
Frequency
|
| 46 |
LAST_TMPL_ITEM |
Number(6,0) |
INTEGER NOT NULL |
Last Form Item Code
|
| 47 |
SETID_DEPT |
Character(5) |
VARCHAR2(5) NOT NULL |
Department SetID
Prompt Table:
SETID_TBL
|
| 48 |
ESS_DEPTID |
Character(10) |
VARCHAR2(10) NOT NULL |
Employee Self Service Deptid
Default Value: 0000
Prompt Table:
PERS_DEPT_VW
|
| 49 |
SECURITY_TYPE |
Character(1) |
VARCHAR2(1) NOT NULL |
Type of Security
C=Permission List Level Security
N=No Security
O=User ID Level Security
Default Value: N
|
| 50 |
BU_SECURITY |
Character(1) |
VARCHAR2(1) NOT NULL |
Business Unit Security
Y/N Table Edit
Default Value: N
|
| 51 |
SETID_SECURITY |
Character(1) |
VARCHAR2(1) NOT NULL |
TableSet ID Security
Y/N Table Edit
Default Value: N
|
| 52 |
ATTACH_TYPE |
Character(5) |
VARCHAR2(5) NOT NULL |
Attachment Type
Prompt Table:
FOATTACHTYP_UPG
|
| 53 |
FO_LAST_RESUME_NBR |
Number(10,0) |
DECIMAL(10) NOT NULL |
Last Resume Number Used
|
| 54 |
RESPROC_MOHO_FTP |
Character(100) |
VARCHAR2(100) NOT NULL |
Extractor FTP Site
|
| 55 |
RESPROC_ROOT_DIR |
Character(100) |
VARCHAR2(100) NOT NULL |
Root Directory
|
| 56 |
RESPROC_ROOT_FTP |
Character(100) |
VARCHAR2(100) NOT NULL |
Root FTP Site
|
| 57 |
RESPROC_RES_FTP |
Character(100) |
VARCHAR2(100) NOT NULL |
Resume FTP Site
|
| 58 |
CONF_THRESHOLD |
Number(3,0) |
SMALLINT NOT NULL |
Resume Confidence Threshold
|
| 59 |
APPLY_ONLINE_URL |
Character(30) |
VARCHAR2(30) NOT NULL |
Apply On-Line URL
Prompt Table:
PSURLDEFN
|
| 60 |
LAST_HIST_ID |
Number(10,0) |
DECIMAL(10) NOT NULL |
Last History ID Assigned
|