BUSINESS_UNITDefault Value: OPR_DEF_TBL_CS.BUSINESS_UNIT
COLLECTION_IDACTIVTY_NBRDefault Value: %date
Prompt Table: COLLECTOR_VW2
Prompt Table: COLLECTOR_VW2
Prompt Table: COLLECT_ROLE_VW
Prompt Table: FOLLOWUP_TBL
Prompt Table: ORG_CNTCT_SF_VW
COLLECT_EFFORT(SQL Table) |
Index Back |
|---|---|
Collection Effort |
| # | 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 |
| 2 | COLLECTION_ID |
Number(12,0) | DECIMAL(12) NOT NULL | Collection ID |
| 3 | ACTIVTY_NBR |
Number(6,0) | INTEGER NOT NULL | Activty Number |
| 4 | ACTIONDTTM | DateTime(26) | TIMESTAMP |
Datetime action was taken on a worklist
Default Value: %date |
| 5 | OPRID | Character(30) | VARCHAR2(30) NOT NULL |
A user's ID (see PSOPRDEFN).
Prompt Table: COLLECTOR_VW2 |
| 6 | SEQ_3C | Number(5,0) | INTEGER NOT NULL | Sequence Number |
| 7 | CHECKLIST_SEQ_3C | Number(5,0) | INTEGER NOT NULL | Checklist Seq Number |
| 8 | COMMENT_SEQ_3C | Number(5,0) | INTEGER NOT NULL | Comment Seq Number |
| 9 | NEXT_REVIEW_DT | Date(10) | DATE | Next Review Date |
| 10 | NEXT_REVIEW_OPRID | Character(30) | VARCHAR2(30) NOT NULL |
Next Review User ID
Prompt Table: COLLECTOR_VW2 |
| 11 | NEXT_REVIEW_ROLE | Character(30) | VARCHAR2(30) NOT NULL |
Next Review Role User
Prompt Table: COLLECT_ROLE_VW |
| 12 | FOLLOW_UP_ACTION | Character(10) | VARCHAR2(10) NOT NULL |
Follow Up Action
Prompt Table: FOLLOWUP_TBL |
| 13 | ORG_CONTACT | Number(4,0) | SMALLINT NOT NULL |
Contact Nbr
Prompt Table: ORG_CNTCT_SF_VW |
| 14 | PHONE | Character(24) | VARCHAR2(24) NOT NULL | Telephone |