EMPLIDREPORT_IDDATE_VALHCSC_SS_DROPDOWNPrompt Table: HCSC_SS_SRC_DVW
FIELD_VALUEPrompt Table: HCSC_SS_SRC_DVW
Prompt Table: HCSC_SS_SRC_DVW
010=Prompt
020=Dropdown
030=AsOfDate
HCSC_SS_RPTFLDT(SQL Table) |
Index Back |
|---|---|
SS Reports Field Attributes |
| # | PeopleSoft Field Name | PeopleSoft Field Type | Database Column Type | Description |
|---|---|---|---|---|
| 1 | EMPLID |
Character(11) | VARCHAR2(11) NOT NULL | Employee ID |
| 2 | REPORT_ID |
Character(8) | VARCHAR2(8) NOT NULL | Report Identifier |
| 3 | DATE_VAL |
Date(10) | DATE | Date Value |
| 4 | HCSC_SS_DROPDOWN |
Character(30) | VARCHAR2(30) NOT NULL |
DropDown Value
Prompt Table: HCSC_SS_SRC_DVW |
| 5 | FIELD_VALUE |
Character(30) | VARCHAR2(30) NOT NULL |
Field Value
Prompt Table: HCSC_SS_SRC_DVW |
| 6 | DESCR50 | Character(50) | VARCHAR2(50) NOT NULL |
Description of length 50
Prompt Table: HCSC_SS_SRC_DVW |
| 7 | FIELDLABEL | Character(30) | VARCHAR2(30) NOT NULL | Field Label |
| 8 | HCSC_SS_FILTER_TYP | Character(3) | VARCHAR2(3) NOT NULL |
Report Filter
010=Prompt 020=Dropdown 030=AsOfDate |
| 9 | FIELDNAME | Character(18) | VARCHAR2(18) NOT NULL | Field Name (see PSDBFIELD). |
| 10 | SEQNBR | Number(5,0) | INTEGER NOT NULL | Sequence Number |
| 11 | PARENTFIELDNAME | Character(18) | VARCHAR2(18) NOT NULL | Field Name |
| 12 | WHERE_CLAUSE | Long Character(500) | VARCHAR2(500) | Where Clause |