REASON_TYPESCD_REASON_SETIDPrompt Table: SCD_SUPSET_VW
Prompt Table: SCD_EVA_RSN_VW
M=Mandatory
N=Not Used
O=Optional
Default Value: N
Y/N Table Edit
Default Value: N
SCD_REASON_DEFS(SQL Table) |
Index Back |
|---|---|
Reason Code DefaultsReason Code Defaults |
| # | PeopleSoft Field Name | PeopleSoft Field Type | Database Column Type | Description |
|---|---|---|---|---|
| 1 | REASON_TYPE |
Character(4) | VARCHAR2(4) NOT NULL | Reason Type |
| 2 | SCD_REASON_SETID |
Character(5) | VARCHAR2(5) NOT NULL |
Reason Code Set ID
Prompt Table: SCD_SUPSET_VW |
| 3 | REASON_CD | Character(10) | VARCHAR2(10) NOT NULL |
Reason Code
Prompt Table: SCD_EVA_RSN_VW |
| 4 | SCD_REASON_CD_REQD | Character(1) | VARCHAR2(1) NOT NULL |
Change Reason Required
M=Mandatory N=Not Used O=Optional Default Value: N |
| 5 | SCD_COMMENTS_REQD | Character(1) | VARCHAR2(1) NOT NULL |
Comments Required Flag
Y/N Table Edit Default Value: N |