HCSC_RTG_HDR_DT(SQL Table) |
Index Back |
|---|---|
Ratings Headers/Row DetailsIdentify the headers and row details for the Ratings pages. In addition, defined the style formats for the headers or row details on this table. Use the default flag to identify the headers. |
| # | 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 |
Effective Date
Default Value: %date |
| 3 | HCSC_RTG_SEQNUM |
Number(3,0) | SMALLINT NOT NULL | Sequence |
| 4 | FIELDNAME | Character(18) | VARCHAR2(18) NOT NULL |
Field Name (see PSDBFIELD).
Prompt Table: HCSC_RTG_FLD0VW |
| 5 | RECNAME | Character(15) | VARCHAR2(15) NOT NULL |
Record (Table) Name (see PSRECDEFN).
Prompt Table: PSRECDEFN_VW |
| 6 | HCSC_RTG_REL_FIELD | Character(18) | VARCHAR2(18) NOT NULL |
Related Fieldname
Prompt Table: HCSC_RTG_FLD1VW |
| 7 | HCSC_RTG_HDR_STYLE | Character(1) | VARCHAR2(1) NOT NULL |
Header Style
1=Header 2=Bold Text 3=Plain Text Default Value: 1 |
| 8 | HCSC_RTG_HDR_DEF | Character(1) | VARCHAR2(1) NOT NULL |
Header Default
Y/N Table Edit Default Value: N |
| 9 | HCSC_RTG_ROW_HDR | Character(1) | VARCHAR2(1) NOT NULL |
Row Details
Y/N Table Edit Default Value: N |