HCSC_EMAIL_TMPL_IDPrompt Table: EOAWPACKAGE_VW
Prompt Table: PSPACKAGPATH_VW
Prompt Table: PSPACKAGCLAS_VW
Prompt Table: PSPACKAGCLAS_VW
P=Public Access
S=Security Access
Default Value: P
Y/N Table Edit
HCSC_NOTIF_TMPL(SQL Table) |
Index Back |
|---|---|
Notification Email TemplateRecord to maintain Email Template configuration for HR Notification |
| # | PeopleSoft Field Name | PeopleSoft Field Type | Database Column Type | Description |
|---|---|---|---|---|
| 1 | HCSC_EMAIL_TMPL_ID |
Character(30) | VARCHAR2(30) NOT NULL | Email Template ID |
| 2 | PACKAGEROOT | Character(30) | VARCHAR2(30) NOT NULL |
Root Package ID
Prompt Table: EOAWPACKAGE_VW |
| 3 | QUALIFYPATH | Character(127) | VARCHAR2(127) NOT NULL |
Qualified Package/Class Path
Prompt Table: PSPACKAGPATH_VW |
| 4 | APPCLASSID | Character(30) | VARCHAR2(30) NOT NULL |
Application Class ID
Prompt Table: PSPACKAGCLAS_VW |
| 5 | APPCLASSMETHOD | Character(60) | VARCHAR2(60) NOT NULL |
Application Class Method Name
Prompt Table: PSPACKAGCLAS_VW |
| 6 | HCSC_TMPL_SEC_TYPE | Character(1) | VARCHAR2(1) NOT NULL |
Security Type
P=Public Access S=Security Access Default Value: P |
| 7 | SYSTEM_DATA_FLG | Character(1) | VARCHAR2(1) NOT NULL |
This Y/ N field is used to identify which rows in a table are considered SYSTEM DATA.
Y/N Table Edit |