| # |
PeopleSoft Field Name |
PeopleSoft Field Type |
Database Column Type |
Description |
| 1 |
 SCD_EVALUATION_ID |
Character(10) |
VARCHAR2(10) NOT NULL |
Evaluation ID
|
| 2 |
SCD_EVAL_NAME |
Character(30) |
VARCHAR2(30) NOT NULL |
Evaluation Name
|
| 3 |
SCD_EVAL_STATUS |
Character(2) |
VARCHAR2(2) NOT NULL |
Evaluation Build Status
OP=Pending and Released
PE=Pending
PO=Posted
RE=Released
WD=Withdrawn
|
| 4 |
SCD_SERVICE_COMP |
Character(30) |
VARCHAR2(30) NOT NULL |
Service Completed
|
| 5 |
SCD_OWNER_ID |
Character(30) |
VARCHAR2(30) NOT NULL |
Owner ID
Prompt Table:
PSOPRDEFN_SRCH
|
| 6 |
SCD_EVAL_PD_TYPE |
Character(2) |
VARCHAR2(2) NOT NULL |
Evaluator Period Type
AH=Ad-Hoc
CP=Calendar Period
Default Value: CP
|
| 7 |
SCD_CAL_SETID |
Character(5) |
VARCHAR2(5) NOT NULL |
Calendar Set ID
Prompt Table:
SP_SETID_NONVW
|
| 8 |
CALENDAR_ID |
Character(2) |
VARCHAR2(2) NOT NULL |
Calendar ID
Prompt Table:
SCD_PRO_CAL_VW
Set Control Field: SCD_CAL_SETID
|
| 9 |
FISCAL_YEAR |
Number(4,0) |
SMALLINT NOT NULL |
Fiscal Year
Prompt Table:
SCD_PRO_CLFY_VW
|
| 10 |
ACCOUNTING_PERIOD |
Number(3,0) |
SMALLINT NOT NULL |
Identifies a time period to which you post transactions. Typically, an accounting period represents a month, but it can also represent a week, a day, or any user-defined interval. An accounting period has a beginning date and an ending date, and is defined in the calendar table.
Prompt Table:
SCD_PRO_CLPE_VW
|
| 11 |
SCD_EVAL_YEAR |
Number(4,0) |
SMALLINT NOT NULL |
Evaluation Year
|
| 12 |
SCD_EVAL_PERIOD |
Number(3,0) |
SMALLINT NOT NULL |
Evaluation Period.
|
| 13 |
SCD_FROM_DATE |
Date(10) |
DATE |
From Date
|
| 14 |
SCD_TO_DATE |
Date(10) |
DATE |
To Date
|
| 15 |
SCD_TEMPLATE_ID |
Character(10) |
VARCHAR2(10) NOT NULL |
Template ID
Prompt Table:
SCD_TEMPLATE_HD
|
| 16 |
SCD_VERSION_NBR |
Number(5,0) |
INTEGER NOT NULL |
Version Number
|
| 17 |
SCD_PLAN_REL_DATE |
Date(10) |
DATE NOT NULL |
Planned Release Date
|
| 18 |
SCD_RELEASED_DATE |
Date(10) |
DATE |
Released Date
|
| 19 |
SCD_POSTED_DATE |
Date(10) |
DATE |
Posted Date
|
| 20 |
SCD_WITHDRAWN_DATE |
Date(10) |
DATE |
Withdrawn Date
|
| 21 |
SCD_NEW_TEMPL_VERS |
Character(1) |
VARCHAR2(1) NOT NULL |
Allow Versions Flag
Y/N Table Edit
Default Value: N
|
| 22 |
SCD_EVALTEE_SETID |
Character(5) |
VARCHAR2(5) NOT NULL |
Evaluatee Set ID
Prompt Table:
SCD_SUPSET_VW
|
| 23 |
SCD_EVALUATEE_ID |
Character(30) |
VARCHAR2(30) NOT NULL |
Evaluatee ID
Prompt Table:
SCD_SUPPLIER_VW
|
| 24 |
SCD_DUE_DATE |
Date(10) |
DATE |
Due Date
|
| 25 |
SCD_ALLOW_DECLINES |
Character(1) |
VARCHAR2(1) NOT NULL |
Allow Declines Flag
Y/N Table Edit
Default Value: INSTALLATION_SC.SCD_ALLOW_DECLINES
|
| 26 |
SCD_TARGET_PCT |
Number(10,6) |
DECIMAL(9,6) NOT NULL |
Target Percent
|
| 27 |
SCD_TARGET_QTY |
Number(3,0) |
SMALLINT NOT NULL |
Target Quantity
|
| 28 |
SCD_SCORE |
Signed Number(11,6) |
DECIMAL(9,6) NOT NULL |
Scorecarding Score
|
| 29 |
SCD_SCORE_UPD_DTTM |
DateTime(26) |
TIMESTAMP |
Score Updated Date Time
|
| 30 |
CREATEDTTM |
DateTime(26) |
TIMESTAMP |
DateTime of Query Creation
|
| 31 |
CREATED_BY |
Character(30) |
VARCHAR2(30) NOT NULL |
Created By
|
| 32 |
LASTUPDDTTM |
DateTime(26) |
TIMESTAMP |
Specifies the date and time of the last update to an entry. This field is maintained by PeopleSoft and is used in a variety of contexts.
|
| 33 |
LASTUPDOPRID |
Character(30) |
VARCHAR2(30) NOT NULL |
Specifies the User ID which made the last update to an entry. This field is maintained by PeopleSoft and is used in a variety of contexts.
|
| 34 |
SCD_DESCR_LONG |
Long Character |
CLOB |
Long Description
|
| 35 |
SCD_INSTRUCTIONS |
Long Character |
CLOB |
Instructions
|