EOEW_ETLC_FLST

(SQL Table)
 Index Back

ETL control for field list

Used to resolve subrecords on PSRECFIELD, provide complete field list based on record.

# PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description
1 EOEW_SRC_OBJ Character(30) VARCHAR2(30) NOT NULL Source Object
2 RECNAME Character(15) VARCHAR2(15) NOT NULL Record (Table) Name (see PSRECDEFN).
3 EOEW_SRC_TYP Character(1) VARCHAR2(1) NOT NULL Source Type
0=Reserved
1=Record
2=Data Object
4 FIELDNAME Character(18) VARCHAR2(18) NOT NULL Field Name (see PSDBFIELD).
5 EOEW_SRCCOLALIAS Character(30) VARCHAR2(30) NOT NULL Column Alias
6 VERSION Number(10,0) DECIMAL(10) NOT NULL Version. Internal PeopleTools version for controlling caching of object. - Version/Table reference
7 FIELDNUM Number(4,0) SMALLINT NOT NULL Field Number
8 SUBRECNAME Character(15) VARCHAR2(15) NOT NULL Subrecord (Table) Name
9 SUBRECORD Character(1) VARCHAR2(1) NOT NULL Sub Record
10 DESCR Character(30) VARCHAR2(30) NOT NULL Description
11 USEEDIT Number(10,0) DECIMAL(10) NOT NULL Field Use and Edit Flags- USEEDIT reference
12 KEY_FIELD_FLG Character(1) VARCHAR2(1) NOT NULL Key Field
13 FIELDTYPE Number(2,0) SMALLINT NOT NULL Field Type (from PSST0101 Ref.)
14 LENGTH Number(5,0) INTEGER NOT NULL Length
15 DECIMALPOS Number(2,0) SMALLINT NOT NULL Decimal Positions
16 FORMAT Number(2,0) SMALLINT NOT NULL Field Format
0=
  • If Fieldtype=0 (Character) then Upper Case
  • If 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)
    • 17 CREATEDTTM DateTime(26) TIMESTAMP NOT NULL DateTime of Query Creation

    Default Value: %datetime

    18 LASTUPDDTTM DateTime(26) TIMESTAMP NOT NULL Specifies the date and time of the last update to an entry. This field is maintained by PeopleSoft and is used in a variety of contexts.

    Default Value: %datetime

    19 LASTUPDOPRID Character(30) VARCHAR2(30) NOT NULL Specifies the User ID which made the last update to an entry. This field is maintained by PeopleSoft and is used in a variety of contexts.