Form: Title : Maintain Standard Settlement Configurations and assign Time SSCTMAIN Patterns. Block: ISC Base table on idb_sscs Query, Update, Delete, Insert allowed. Join columns: sscs.ssc_id = mear.ssc_id Order by ssc_id Label : SSC ssc_id Display. User Enterable. Query. Insert. Delete. Label : Description Ssc_desc Display. User Enterable. Query. Insert. Update. Delete. Label : Tele-switch User Teleswitch_User_Id Display. User Enterable. Query. Insert. Update. Delete. LoV available based on distinct values from idb_sscs. Validation: Range check against cdb_ref_values where domain_code = ‘TSUI’. Label : Tele-switch Group Teleswitch_Group_Id Display. User Enterable. Query. Insert. Update. Delete. LoV available based on idb_sscs where sccs.teleswitch_user_id = specified Tele-switch User. Validation: Range check against cdb_ref_values where domain_code = ‘TSGI’. Label : SSC Type SSC Type Display. User Enterable. Query. Insert. Update. LoV available, currently only E or I. Validation: Must be in cdb_ref_values where domain_code = ‘SSCT’. Label : Active. Active_flag Display. User Enterable.. Query. Insert. Update. Delete. Block: non-base table. CTRL Display only. Join columns: ctrl.nbt_ssc_id = sscs.ssc_id ctrl.nbt_ssc_desc = sscs.ssc_desc Label : SSC Nbt_ssc_id Display only. Label : Description Nbt_ssc_desc Display only.
Form: SSCTMAIN Title : Maintain Standard Settlement Configurations and assign Time Patterns. Block: ISC Base table on idb_sscs Query, Update, Delete, Insert allowed. Join columns: sscs.ssc_id = mear.ssc_id Order by ssc_id ssc_id Label : SSC Display. User Enterable. Query. Insert. Delete. Ssc_desc Label : Description Display. User Enterable. Query. Insert. Update. Delete. Teleswitch_User_Id Label : Tele-switch User Display. User Enterable. Query. Insert. Update. Delete. LoV available based on distinct values from idb_sscs. Validation: Range check against cdb_ref_values where domain_code = ‘TSUI’. Teleswitch_Group_Id Label : Tele-switch Group Display. User Enterable. Query. Insert. Update. Delete. LoV available based on idb_sscs where sccs.teleswitch_user_id = specified Tele-switch User. Validation: Range check against cdb_ref_values where domain_code = ‘TSGI’. SSC Type Label : SSC Type Display. User Enterable. Query. Insert. Update. LoV available, currently only E or I. Validation: Must be in cdb_ref_values where domain_code = ‘SSCT’. Active_flag Label : Active. Display. User Enterable.. Query. Insert. Update. Delete. Block: CTRL non-base table. Display only. Join columns: ctrl.nbt_ssc_id = sscs.ssc_id ctrl.nbt_ssc_desc = sscs.ssc_desc Nbt_ssc_id Label : SSC Display only. Nbt_ssc_desc Label : Description Display only.
SVAAISRA_Technical_Spec_redlined_v27.2_CP1418.docx