STANDRD_LTR_VW(SQL View) |
Index Back |
---|---|
Standard Letter Codes ViewSTANDRD_LTR_VW reverses the Letter_Cd and Admin_Function fields for prompting purposes via the Admin_Function. |
SELECT ADMIN_FUNCTION , SCC_LETTER_CD , DESCR , ENCL_TYPE FROM PS_SCC_STN_LTR_TBL |
# | PeopleSoft Field Name | PeopleSoft Field Type | Database Column Type | Description |
---|---|---|---|---|
1 | ADMIN_FUNCTION | Character(4) | VARCHAR2(4) NOT NULL | Administrative Function |
2 | SCC_LETTER_CD | Character(3) | VARCHAR2(3) NOT NULL | Letter Code |
3 | DESCR | Character(30) | VARCHAR2(30) NOT NULL | Description |
4 | ENCL_TYPE | Character(1) | VARCHAR2(1) NOT NULL |
Enclosure Type
H=Hardcopy S=Softcopy |