WCS_SO_ORIENT

(SQL Table)
Index Back

Source Orientations

Orientations for sources. The orientation describes a starting point for the sources. This starting point is made up of basic data, such as employee ID, that the application using the source will likely have available.

  • Related Language Record: WCS_SO_ORNT_LNG
  • # PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description
    1 ORIENTATION Character(10) VARCHAR2(10) NOT NULL This describes how a Configurable Matrix's Sources will attempt to dynamically resolve themselves. It is an indication of the minimum set of application keys which must be supplied, and the set of tables the Source will analyze.
    2 DESCR Character(30) VARCHAR2(30) NOT NULL Description
    3 DATA_TYPE_CD Character(1) VARCHAR2(1) NOT NULL Data Type Code
    N=Customer Data
    S=Sample Data
    Y=System Data

    Default Value: N