POS_SRC_FLD_VW

(SQL View)
 Index Back

Positions Data Source Table 2


SELECT SETID ,POS_SOURCE_ID ,A.ALIAS_NAME ,A.FIELDNAME ,A.FIELDTYPE ,FIELD_PROMPT ,A.FORMAT ,B.META_FIELD ,B.META_TEXT FROM PS_POS_SOURCE_TBL2 A, PS_POS_FIELD_TYPE B Where A.ALIAS_NAME= B.ALIAS_NAME

# 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
4 FIELDNAME Character(18) VARCHAR2(18) NOT NULL Field Name (see PSDBFIELD).

Prompt Table: POS_FIELD_TYPE

5 FIELDTYPE Number(2,0) SMALLINT NOT NULL Field Type (from PSST0101 Ref.)
6 FIELD_PROMPT Character(15) VARCHAR2(15) NOT NULL Record Prompt

Prompt Table: RECDEFN_VW

7 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)
    • 8 META_FIELD Character(2) VARCHAR2(2) NOT NULL Allows the user to create a specialized data variable that can be utilized in building a position data source.
    9 META_TEXT Character(250) VARCHAR2(250) NOT NULL The specific SQL text utilized in order to create a specialized data variable that can be utilized in building a