LETTER_CDAPP=Recruitment Letters
CBR=COBRA Letters
CUST=Customers Letters
HIPA=HIPAA Certificate
MLR=Manage Labor Relation
REV=Employee Review Letters
TRN=Training Letters
STANDRD_LTR_TBL(SQL Table) |
Index Back |
|---|---|
Standard Letter CodesSTANDRD_LTR_TBL houses the codes for standard letters produced by modules such as Recruitment and Training Administration. Standard letters are sent to applicants and students in response to certain activities. For example, you could send a letter to an applicant to invite them to an interview, or you could send a letter to a student to notify them of enrollment in a course. A set of letter codes is delivered with your PeopleSoft HR system. |
| # | PeopleSoft Field Name | PeopleSoft Field Type | Database Column Type | Description |
|---|---|---|---|---|
| 1 | LETTER_CD |
Character(3) | VARCHAR2(3) NOT NULL | Letter code |
| 2 | SET_LETTER_CD | Character(4) | VARCHAR2(4) NOT NULL |
Set Letter Code
APP=Recruitment Letters CBR=COBRA Letters CUST=Customers Letters HIPA=HIPAA Certificate MLR=Manage Labor Relation REV=Employee Review Letters TRN=Training Letters |
| 3 | DESCR | Character(30) | VARCHAR2(30) NOT NULL | Description |
| 4 | DESCRSHORT | Character(10) | VARCHAR2(10) NOT NULL | Short Description |