SETIDPrompt Table: SP_SETID_NONVW
CF_MCHG_RULEEFFDTDefault Value: %date
FAI_MCHG_RULEVW(SQL View) |
Index Back |
|---|---|
CF Mass Change Rule Definition |
| SELECT a.setid ,a.cf_mchg_rule , c.effdt , a.cf_mchg_group , a.seq_num , c.sql_stmt FROM ps_fai_mchg_grp_ln a , PS_FAI_MCHG_RULE c WHERE a.setid=c.setid AND a.cf_mchg_rule=c.cf_mchg_rule AND c.effdt=( SELECT MAX(effdt) FROM PS_FAI_MCHG_RULE R WHERE r.setid=c.setid AND r.cf_mchg_rule=c.cf_mchg_rule) AND a.effdt=( SELECT MAX(effdt) FROM ps_fai_mchg_grp_ln R1 WHERE r1.setid=a.setid AND r1.cf_mchg_rule=a.cf_mchg_rule AND r1.cf_mchg_GROUP=a.cf_mchg_GROUP) |
| # | PeopleSoft Field Name | PeopleSoft Field Type | Database Column Type | Description |
|---|---|---|---|---|
| 1 | SETID |
Character(5) | VARCHAR2(5) NOT NULL |
SetID
Prompt Table: SP_SETID_NONVW |
| 2 | CF_MCHG_RULE |
Character(10) | VARCHAR2(10) NOT NULL | Chartfield Mass Change Rule |
| 3 | EFFDT |
Date(10) | DATE NOT NULL |
Effective Date
Default Value: %date |
| 4 | CF_MCHG_GROUP | Character(10) | VARCHAR2(10) NOT NULL | Chartfield Mass Change Group |
| 5 | SEQ_NUM | Number(3,0) | SMALLINT NOT NULL | Sequence |
| 6 | SQL_STMT | Long Character(8192) | CLOB | An internal work field that contains SQL text that is to be utilized in treasury application processing. |