SSF_COLLECT_ORG(SQL View) |
Index Back |
|---|---|
Ext Org Collection Search Rec |
| SELECT BUSINESS_UNIT , COLLECTION_ID , EXT_ORG_ID , NEXT_REVIEW_OPRID , NEXT_REVIEW_ROLE , NEXT_REVIEW_DT , COLLECTION_STATUS FROM PS_COLLECTION_SF WHERE ORG_PERSON = 'O' |
| # | 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: SP_BU_SF_NONVW |
| 2 | COLLECTION_ID |
Number(12,0) | DECIMAL(12) NOT NULL | Collection ID |
| 3 | EXT_ORG_ID | Character(11) | VARCHAR2(11) NOT NULL |
External Org ID
Prompt Table: EXT_ORG_TBL |
| 4 | NEXT_REVIEW_OPRID | Character(30) | VARCHAR2(30) NOT NULL |
Collector User ID
Prompt Table: COLLECTOR_VW2 |
| 5 | NEXT_REVIEW_ROLE | Character(30) | VARCHAR2(30) NOT NULL |
Role
Prompt Table: COLLECT_ROLE_VW |
| 6 | NEXT_REVIEW_DT | Date(10) | DATE | Next Review Date |
| 7 | COLLECTION_STATUS | Character(1) | VARCHAR2(1) NOT NULL |
Collection Status
A=Active being Collected C=Closed H=Hold All Collection Efforts I=Initial Collection Status N=Not Active Collected |