REASON_TYPEDefault Value: TMCH
Prompt Table: SP_SETID_NONVW
Prompt Table: SCD_TMP_RSN_VW
M=Mandatory
N=Not Used
O=Optional
Default Value: N
Y/N Table Edit
SCD_TMP_RSN_DEF(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
Default Value: TMCH |
| 2 | SCD_REASON_SETID | Character(5) | VARCHAR2(5) NOT NULL |
Reason Code Set ID
Prompt Table: SP_SETID_NONVW |
| 3 | REASON_CD | Character(10) | VARCHAR2(10) NOT NULL |
Reason Code
Prompt Table: SCD_TMP_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 |