HCSC_RTG_CDEFFDTHCSC_RTG_SEQNUMN=No
Y=Yes
Y/N Table Edit
Default Value: N
Prompt Table: PSMSGSETDEFN
Prompt Table: PSMSGCATDEFN
HCSC_RTG_DFNLNK(SQL Table) |
Index Back |
|---|---|
Ratings Customized LinksStore all customized links that the application will used for specific processing. |
| # | 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 | HCSC_RTG_SEQNUM |
Number(3,0) | SMALLINT NOT NULL | Sequence |
| 4 | SELECT_FLAG | Character(1) | VARCHAR2(1) NOT NULL |
Selection Flag
N=No Y=Yes Y/N Table Edit Default Value: N |
| 5 | 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 |
| 6 | MESSAGE_NBR | Number(5,0) | INTEGER NOT NULL |
Message Number. This field refers to the Message Number in the Message Catalog.
Prompt Table: PSMSGCATDEFN |
| 7 | HCSC_RTG_LABEL | Character(100) | VARCHAR2(100) NOT NULL | Ratings Label |