HCSC_RTG_CDEFFDTFIELDNAMEPrompt Table: HCSC_RTG_FLD0VW
HCSC_RTG_ORDER_BYA=Ascending
D=Descending
Default Value: A
Prompt Table: PSMSGSETDEFN
Prompt Table: PSMSGCATDEFN
HCSC_RTG_SORT(SQL Table) |
Index Back |
|---|---|
Ratings Sort FieldsIdentify 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 | HCSC_RTG_SORT_BY | Number(3,0) | SMALLINT NOT NULL | Rating and Reviews Sort By |
| 6 | MESSAGE_SET_NBR | Number(5,0) | INTEGER NOT NULL |
Message Set Number. This field refers to the Message Set Number in the Message Catalog.
Prompt Table: PSMSGSETDEFN |
| 7 | MESSAGE_NBR | Number(5,0) | INTEGER NOT NULL |
Message Number. This field refers to the Message Number in the Message Catalog.
Prompt Table: PSMSGCATDEFN |
| 8 | HCSC_RTG_LABEL | Character(100) | VARCHAR2(100) NOT NULL | Ratings Label |