BUSINESS_UNITDefault Value: SEL_CRITR_TBL.BUSINESS_UNIT
Prompt Table: SP_BU_SF_NONVW
CRITERIADefault Value: SEL_CRITR_TBL.CRITERIA
Prompt Table: SEL_GROUP_TBL
EFFDTDefault Value: SEL_CRITR_TBL.EFFDT
SEQNOLANGUAGE_CDSEL_CRITER_LNG(SQL Table) |
Index Back |
|---|---|
Related Lang-Group SelectorSEL_CRITER_LNG is the language record related to SEL_CRITER_TBL A related language record enables text fields on a table to be translated into various languages for use in other countries. |
| # | PeopleSoft Field Name | PeopleSoft Field Type | Database Column Type | Description |
|---|---|---|---|---|
| 1 | BUSINESS_UNIT |
Character(5) | VARCHAR2(5) NOT NULL |
Business Unit
Default Value: SEL_CRITR_TBL.BUSINESS_UNIT Prompt Table: SP_BU_SF_NONVW |
| 2 | CRITERIA |
Character(12) | VARCHAR2(12) NOT NULL |
Criteria for Selector
Default Value: SEL_CRITR_TBL.CRITERIA Prompt Table: SEL_GROUP_TBL |
| 3 | EFFDT |
Date(10) | DATE NOT NULL |
Effective Date
Default Value: SEL_CRITR_TBL.EFFDT |
| 4 | SEQNO |
Number(5,0) | INTEGER NOT NULL | Sequence Number |
| 5 | LANGUAGE_CD |
Character(3) | VARCHAR2(3) NOT NULL | Language Code |