RF_SO_REASON_VW(SQL View) |
Index Back |
---|---|
Reason Codes for Service OrderThis view is used by Field Service for providing the Billing Adjustment reason for Service Order. |
SELECT A.SETID , A.REASON_CD , A.DESCR , A.DESCR1 FROM PS_RB_REASON_CD A WHERE A.REASON_TYPE = 'SOBA' AND A.EFF_STATUS = 'A' AND A.EFFDT = ( SELECT MAX(A_ED.EFFDT) FROM PS_RB_REASON_CD A_ED WHERE A.SETID = A_ED.SETID AND A.REASON_CD = A_ED.REASON_CD AND A_ED.EFFDT <= %CurrentDateIn) |
# | PeopleSoft Field Name | PeopleSoft Field Type | Database Column Type | Description |
---|---|---|---|---|
1 | SETID | Character(5) | VARCHAR2(5) NOT NULL |
This field is used to store the value of SetID on various setup tables.
Default Value: OPR_DEF_TBL_RB.SETID Prompt Table: SP_SETID_NONVW |
2 | REASON_CD | Character(10) | VARCHAR2(10) NOT NULL | Used to store the identification number for the reason code. |
3 | DESCR | Character(30) | VARCHAR2(30) NOT NULL | Description |
4 | DESCR1 | Character(30) | VARCHAR2(30) NOT NULL | Self-Service Description |