INSTALLATION_SC(SQL Table) |
Index Back |
|---|---|
Scorecarding InstallationScorecarding Installation table |
| # | PeopleSoft Field Name | PeopleSoft Field Type | Database Column Type | Description |
|---|---|---|---|---|
| 1 | SCD_ALLOW_DECLINES | Character(1) | VARCHAR2(1) NOT NULL |
Allow Declines Flag
Y/N Table Edit Default Value: N |
| 2 | SCD_SUPPLIER_SETID | Character(5) | VARCHAR2(5) NOT NULL | Supplier Set ID |
| 3 | SCD_TRCBK_DYS_TRND | Number(4,0) | SMALLINT NOT NULL |
Trace Back Days
Default Value: 365 |
| 4 | SCD_TRCBK_DYS_RANK | Number(4,0) | SMALLINT NOT NULL |
Trace Back Days
Default Value: 90 |
| 5 | SCD_VNDR_SEL_TRND | Character(2) | VARCHAR2(2) NOT NULL |
Supplier Selection Option
LS=Recently Evaluated Default Value: LS |
| 6 | SCD_VNDR_SEL_RANK | Character(2) | VARCHAR2(2) NOT NULL |
Supplier Selection Option
LS=Recently Evaluated Default Value: LS |
| 7 | SCD_VNDSEL_TM_FRM | Number(4,0) | SMALLINT NOT NULL |
Supplier Selection Days
Default Value: 120 |