| # |
PeopleSoft Field Name |
PeopleSoft Field Type |
Database Column Type |
Description |
| 1 |
 XML_NODE_ID |
Character(6) |
VARCHAR2(6) NOT NULL |
Root node
|
| 2 |
XML_SET |
Character(5) |
VARCHAR2(5) NOT NULL |
XML Set
Prompt Table:
XML_SET_TBL
|
| 3 |
DESCR50 |
Character(50) |
VARCHAR2(50) NOT NULL |
Description of length 50
|
| 4 |
XML_NODE_TYPE |
Character(1) |
VARCHAR2(1) NOT NULL |
Node type
C=Complex
S=Simple
|
| 5 |
XML_NODE_NM |
Character(50) |
VARCHAR2(50) NOT NULL |
Tag node
|
| 6 |
XML_ROOT |
Character(1) |
VARCHAR2(1) NOT NULL |
Root node
Y/N Table Edit
Default Value: N
|
| 7 |
XML_VALIDATION |
Character(1) |
VARCHAR2(1) NOT NULL |
Validation type
1=Xlat Field
3=Code Table
4=Date
5=Time
N=None
Default Value: N
|
| 8 |
XML_SOURCE_DATA |
Character(1) |
VARCHAR2(1) NOT NULL |
Source data
M=Manual
S=System Table
Default Value: S
|
| 9 |
XML_XLAT_CODE |
Character(8) |
VARCHAR2(8) NOT NULL |
XML translate table codes
Prompt Table:
XML_XLATDEFN
|
| 10 |
XML_LENGTH |
Number(3,0) |
SMALLINT NOT NULL |
Field Length
|
| 11 |
XML_FORMAT_DATE |
Character(10) |
VARCHAR2(10) NOT NULL |
Format
|
| 12 |
RECNAME |
Character(15) |
VARCHAR2(15) NOT NULL |
Record (Table) Name (see PSRECDEFN).
Prompt Table:
XML_SET_RECORDS
|
| 13 |
FIELDNAME |
Character(18) |
VARCHAR2(18) NOT NULL |
Field Name (see PSDBFIELD).
Prompt Table:
%EDITTABLE
|
| 14 |
REQUIRED_FIELD |
Character(1) |
VARCHAR2(1) NOT NULL |
* Required Field
Y/N Table Edit
|
| 15 |
XML_CONCAT_FLG |
Character(1) |
VARCHAR2(1) NOT NULL |
Concatenate
Y/N Table Edit
Default Value: N
|
| 16 |
XML_CONCAT_NODE |
Character(6) |
VARCHAR2(6) NOT NULL |
Node Id
Prompt Table:
XML_NODE_S_VW
|
| 17 |
XML_MAPPING_FROM |
Character(1) |
VARCHAR2(1) NOT NULL |
Mapping By
M=Manual
N=None
R=Record
X=Xlat
Default Value: N
|
| 18 |
XML_MAPPING_TO |
Character(1) |
VARCHAR2(1) NOT NULL |
Mapping To
C=Code Table
M=Manual
N=None
Default Value: N
|
| 19 |
RECNAME_EDIT |
Character(15) |
VARCHAR2(15) NOT NULL |
Edit Table for Record
Prompt Table:
XML_REC_VW_ESP
|
| 20 |
REG_REGION |
Character(5) |
VARCHAR2(5) NOT NULL |
Regulatory Region
Prompt Table:
REG_STANDARD_VW
|
| 21 |
XML_MAP_CODETBL |
Character(8) |
VARCHAR2(8) NOT NULL |
XML Code table
Prompt Table:
XML_XLATDEFN
|
| 22 |
XML_FORMAT_FLG |
Character(4) |
VARCHAR2(4) NOT NULL |
Format flag
DD=Day
DY2=DDMMYY
DY2-=DD-MM-YY
DY2/=DD/MM/YY
DY4=DDMMYYYY
DY4-=DD-MM-YYYY
DY4/=DD/MM/YYYY
MM=Month
MY2=MMDDYY
MY2-=MM-DD-YY
MY2/=MM/DD/YY
MY4=MMDDYYYY
MY4-=MM-DD-YYYY
MY4/=MM/DD/YYYY
NONE=None
Y2=YYMMDD
Y2-=YY-MM-DD
Y2/=YY/MM/DD
Y4=YYYYMMDD
Y4-=YYYY-MM-DD
Y4/=YYYY/MM/DD
YY=Year (2)
Default Value: NONE
|
| 23 |
XML_NODE_VALUE |
Character(50) |
VARCHAR2(50) NOT NULL |
Node value
|
| 24 |
XML_SUBSTRING |
Character(1) |
VARCHAR2(1) NOT NULL |
Substring
Y/N Table Edit
Default Value: N
|
| 25 |
XML_SUBSTRNG_START |
Number(3,0) |
SMALLINT NOT NULL |
Start Position
|
| 26 |
XML_SUBSTRNG_LNGTH |
Number(3,0) |
SMALLINT NOT NULL |
Length
|
| 27 |
XML_FORMAT_HRS_FLG |
Character(4) |
VARCHAR2(4) NOT NULL |
Hours Format flag
HM=hhmm
HM-=hh-mm
HM:=hh:mm
NONE=None
Default Value: NONE
|
| 28 |
XML_USE_DESCR_FLG |
Character(1) |
VARCHAR2(1) NOT NULL |
Use Description
Y/N Table Edit
|
| 29 |
XML_ATTRB_FLG |
Character(1) |
VARCHAR2(1) NOT NULL |
Use Attributes Flag
Y/N Table Edit
Default Value: N
|
| 30 |
XML_CLEAN_FLG |
Character(1) |
VARCHAR2(1) NOT NULL |
Clean String Flag
Y/N Table Edit
Default Value: N
|
| 31 |
XML_CLEAN_STRING |
Character(20) |
VARCHAR2(20) NOT NULL |
Clean String Flag
|
| 32 |
XML_NODE_OWNER |
Character(1) |
VARCHAR2(1) NOT NULL |
Owner
N=Customer
S=Peoplesoft Sample Data
Y=PeopleSoft System Data
|
| 33 |
XML_USE_FIELD_EDIT |
Character(1) |
VARCHAR2(1) NOT NULL |
Use Related Field
Y/N Table Edit
|
| 34 |
XML_RECNAME_EDIT |
Character(15) |
VARCHAR2(15) NOT NULL |
Record Name - Edit
|
| 35 |
XML_FIELDNAME_EDIT |
Character(18) |
VARCHAR2(18) NOT NULL |
Field Name Edit
Prompt Table:
XML_RECFLD_ESP
|
| 36 |
XML_SPEC_FORMT_FLG |
Character(1) |
VARCHAR2(1) NOT NULL |
Special Format Flag
Y/N Table Edit
|
| 37 |
XML_SPECIAL_FORMAT |
Character(4) |
VARCHAR2(4) NOT NULL |
Special Format
4D=Transforms Percent to 4 Digits
CUST=Customiztn with App Classes
FMTC=First Map Then Concat
H4M2=Hours & Minutes
NOSP=Remove Spaces
SEPC=Decimal Separator is a Comma
SEPP=Decimal Separator is a Point
ZERO=Transforms Zero to Space
|
| 38 |
XML_FILL_FLG |
Character(1) |
VARCHAR2(1) NOT NULL |
Fill
Y/N Table Edit
Default Value: N
|
| 39 |
XML_FILL_CHAR |
Character(1) |
VARCHAR2(1) NOT NULL |
Char Fill
|
| 40 |
XML_FILL_LNGTH |
Number(3,0) |
SMALLINT NOT NULL |
Length
|
| 41 |
TIME_STAMP |
DateTime(26) |
TIMESTAMP |
Time Stamp
Default Value: %date
|