HCSC_RTG_CDEFFDTFIELDNAMEPrompt Table: HCSC_RTG_FLD0VW
HCSC_RTG_ORDER_BYA=Ascending
D=Descending
Default Value: A
LANGUAGE_CDHCSC_RTG_SORTLG(SQL Table) |
Index Back |
|---|---|
Ratings Sort Fields Rel LangRelated Language table to identify fieldnames for sorting Ratings pages on this table. Also, identify if sorting is ascending or descending order. |
| # | PeopleSoft Field Name | PeopleSoft Field Type | Database Column Type | Description |
|---|---|---|---|---|
| 1 | HCSC_RTG_CD |
Character(30) | VARCHAR2(30) NOT NULL | Ratings Identification |
| 2 | EFFDT |
Date(10) | DATE NOT NULL | Effective Date |
| 3 | FIELDNAME |
Character(18) | VARCHAR2(18) NOT NULL |
Field Name (see PSDBFIELD).
Prompt Table: HCSC_RTG_FLD0VW |
| 4 | HCSC_RTG_ORDER_BY |
Character(1) | VARCHAR2(1) NOT NULL |
Order By
A=Ascending D=Descending Default Value: A |
| 5 | LANGUAGE_CD |
Character(3) | VARCHAR2(3) NOT NULL | Language Code |
| 6 | HCSC_RTG_LABEL | Character(100) | VARCHAR2(100) NOT NULL | Ratings Label |