COLL_LTRITM_TBL(SQL Table) |
Index Back |
|---|---|
Collection Letter Item Table |
| # | PeopleSoft Field Name | PeopleSoft Field Type | Database Column Type | Description |
|---|---|---|---|---|
| 1 |  SETID |
Character(5) | VARCHAR2(5) NOT NULL |
SetID
Prompt Table: SP_SETID_NONVW |
| 2 | TEMPLATE_CODE |
Character(10) | VARCHAR2(10) NOT NULL | Template Code |
| 3 | EFFDT |
Date(10) | DATE NOT NULL |
Effective Date
Default Value: %date |
| 4 | SEQ_NO |
Number(2,0) | SMALLINT NOT NULL | Sequence Number |
| 5 | SCC_LETTER_CD | Character(3) | VARCHAR2(3) NOT NULL |
Letter Code
Prompt Table: COMM_CTXME_SFVW |
| 6 | DAYS_IN_COLLECTION | Number(3,0) | SMALLINT NOT NULL | Days in Collections |
| 7 | ADMIN_FUNCTION | Character(4) | VARCHAR2(4) NOT NULL |
Administrative Function
Prompt Table: ADM_FUNCTN_TBL |
| 8 | COMM_CATEGORY | Character(6) | VARCHAR2(6) NOT NULL |
Communication Category
Prompt Table: COMM_CATG_SFVW |
| 9 | COMM_CONTEXT | Character(6) | VARCHAR2(6) NOT NULL |
Communication Context
Prompt Table: COMM_CTXT_SFVW |
| 10 | COMM_METHOD | Character(1) | VARCHAR2(1) NOT NULL |
Communication Method
B=Publication D=Document E=Email F=Fax L=Letter P=Personal Contact T=Telephone Call W=Web Default Value: L |
| 11 | DEPTID | Character(10) | VARCHAR2(10) NOT NULL |
Department
Prompt Table: HCR_DEPT_I |