BUSINESS_UNITDefault Value: OPR_DEF_TBL_CS.BUSINESS_UNIT
Prompt Table: BUS_UNIT_TBL_SF
COLLECTION_IDPrompt Table: COLLECTION_SF
Prompt Table: PEOPLE_SRCH
COLL_PER_SRCH(SQL View) |
Index Back |
|---|---|
Person Collection ID ViewThis view is used as a search record for Collection Dunning Letter |
| SELECT BUSINESS_UNIT , COLLECTION_ID , EMPLID FROM PS_COLLECTION_SF WHERE EMPLID <> ' ' AND TEMPLATE_CODE <> ' ' |
| # | PeopleSoft Field Name | PeopleSoft Field Type | Database Column Type | Description |
|---|---|---|---|---|
| 1 | BUSINESS_UNIT |
Character(5) | VARCHAR2(5) NOT NULL |
Business Unit
Default Value: OPR_DEF_TBL_CS.BUSINESS_UNIT Prompt Table: BUS_UNIT_TBL_SF |
| 2 | COLLECTION_ID |
Number(12,0) | DECIMAL(12) NOT NULL |
Collection ID
Prompt Table: COLLECTION_SF |
| 3 | EMPLID | Character(11) | VARCHAR2(11) NOT NULL |
Employee ID
Prompt Table: PEOPLE_SRCH |