CS_AGREE_WF(SQL Table) |
Index Back |
|---|---|
SLA Agree Code WorkflowSCC 01/01/07 F-AHAYT-S60K7 |
| # | PeopleSoft Field Name | PeopleSoft Field Type | Database Column Type | Description |
|---|---|---|---|---|
| 1 |  SETID |
Character(5) | VARCHAR2(5) NOT NULL | SetID |
| 2 | CS_AGREE_CD |
Character(18) | VARCHAR2(18) NOT NULL | Agreement Code for Supplier Contract Managment |
| 3 | EFFDT |
Date(10) | DATE NOT NULL | Effective Date |
| 4 | CS_VERIFY_SEQ |
Number(5,0) | INTEGER NOT NULL |
Contract Agreement Verification Step
Prompt Table: CS_AGREE_VERIFY |
| 5 | CS_WORKFLOW_SEQ |
Number(5,0) | INTEGER NOT NULL | Workflow Sequence for Supplier Contract Managment |
| 6 | CS_WORKFLOW_TYPE | Character(1) | VARCHAR2(1) NOT NULL |
Notification Type flag
0=Agreement 1=Verification Step 2=Agreement and Steps |
| 7 | OPRID | Character(30) | VARCHAR2(30) NOT NULL |
A user's ID (see PSOPRDEFN).
Prompt Table: %EDITTABLE |
| 8 | OPRDEFNDESC | Character(30) | VARCHAR2(30) NOT NULL |
Description field for a user
Prompt Table: CS_OPRDESC_VW |
| 9 | EMAILID | Character(70) | VARCHAR2(70) NOT NULL | A user's E-mail address |
| 10 | USER_TYPE | Character(1) | VARCHAR2(1) NOT NULL |
User Type for Supplier Contract Managment
E=External I=Internal |
| 11 | DAYS_PRIOR_REMIND | Number(4,0) | SMALLINT NOT NULL | Reminder Days Prior to Contract Target Date for Supplier Contract Managment |
| 12 | DAYS_FINAL_REMIND | Number(4,0) | SMALLINT NOT NULL | Nag Days for Supplier Contract Managment |
| 13 | PASSED_DUE_FLAG | Character(1) | VARCHAR2(1) NOT NULL |
Notify User when Contract Target Date is Passed Due for Supplier Contract Managment
Y/N Table Edit Default Value: N |
| 14 | NOTIFY_ON_STAT_CHG | Character(1) | VARCHAR2(1) NOT NULL |
Notify On Status Change
Y/N Table Edit Default Value: N |
| 15 | NOTIFIED_FLAG | Character(1) | VARCHAR2(1) NOT NULL |
Notified Flag
Y/N Table Edit Default Value: N |
| 16 | CS_WARN_PERF | Character(1) | VARCHAR2(1) NOT NULL |
Warning for SLA Metric Result Type
Y/N Table Edit Default Value: N |
| 17 | CS_UNACCEPT_PERF | Character(1) | VARCHAR2(1) NOT NULL |
Uncacceptable Performance for SLA Metric Result
Y/N Table Edit Default Value: N |
| 18 | ALLOW_UPDATE_FLG | Character(1) | VARCHAR2(1) NOT NULL |
Allow Updates
Y/N Table Edit Default Value: N |
| 19 | OVERRIDE_FLAG | Character(1) | VARCHAR2(1) NOT NULL |
Specify Email
Y/N Table Edit Default Value: N |