| # |
PeopleSoft Field Name |
PeopleSoft Field Type |
Database Column Type |
Description |
| 1 |
 SETID |
Character(5) |
VARCHAR2(5) NOT NULL |
SetID
Default Value: OPR_DEF_TBL_FS.SETID
Prompt Table:
SP_SETID_NONVW
|
| 2 |
POS_SOURCE_ID |
Character(18) |
VARCHAR2(18) NOT NULL |
"A unique key identifier that represents a position source dataset
|
| 3 |
ALIAS_NAME |
Character(30) |
VARCHAR2(30) NOT NULL |
"A user defined synonym
Prompt Table:
POS_FIELD_VW
|
| 4 |
FIELDNAME |
Character(18) |
VARCHAR2(18) NOT NULL |
Field Name (see PSDBFIELD).
Prompt Table:
POS_RECFIELD_VW
|
| 5 |
FIELDTYPE |
Number(2,0) |
SMALLINT NOT NULL |
Field Type (from PSST0101 Ref.)
|
| 6 |
FORMAT |
Number(2,0) |
SMALLINT NOT NULL |
Field Format
0=If Fieldtype=0 (Character) then Upper CaseIf Fieldtype=6 (DateTime) then HH:MM
1=Name
2=Phone Number North American (mandatory length 12 characters)
3=Zip/Postal Code North American (mandatory length 10 characters)
4=US Social Security Number (mandatory length 9 characters)
5=
6=Mixed Case
7=Raw/Binary
8=Numbers only
9=SIN (mandatory length 9 characters)
10=International Phone Number
11=Zip/Postal Code International
12=Time HH:MM:SS
13=Time HH:MM:SS.999999
14=Custom (FORMATFAMILY and DISPFMTNAME must be completed)
|
| 7 |
DEFAULT_VALUE |
Character(40) |
VARCHAR2(40) NOT NULL |
Default Value
Prompt Table:
%EDITTABLE
|
| 8 |
DESCR200 |
Character(254) |
VARCHAR2(254) NOT NULL |
Long Description
|