WCS_SOURCE_TYPE(SQL Table) |
Index Back |
---|---|
Source TypesThis record describes the different types of sources. It identifies the classes that control the source and the page that defines the source. |
# | PeopleSoft Field Name | PeopleSoft Field Type | Database Column Type | Description |
---|---|---|---|---|
1 | SOURCE_TYPE_ID | Character(10) | VARCHAR2(10) NOT NULL | Source type classifies sources. It identifies the application class that has the code for the source. It also identifies the design time page. |
2 | DESCR | Character(30) | VARCHAR2(30) NOT NULL | Description |
3 | 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.
Prompt Table: WCS_SO_ORIENT |
4 | PNLNAME | Character(30) | VARCHAR2(30) NOT NULL | Page Name (see PSPNLDEFN). |
5 | APPCLASS_PATH | Character(254) | VARCHAR2(254) NOT NULL | Application Class Full Path |
6 | SOURCE_IMPL_CLASS | Character(254) | VARCHAR2(254) NOT NULL | This field identifies the class used to process the source at run time or during lookup definition. |
7 | DATA_TYPE_CD | Character(1) | VARCHAR2(1) NOT NULL |
Data Type Code
N=Customer Data S=Sample Data Y=System Data Default Value: N |
8 | DISPLAY_CONTROL | Character(1) | VARCHAR2(1) NOT NULL |
Display Control
Y/N Table Edit Default Value: Y |