gethistory.sas File Reference

Returns the list of previously approved / rejected items. More...

Go to the source code of this file.

Detailed Description

History is taken from MPE_SUBMIT (where status_cd ne 'SUBMITTED') and filtered according to the groups in MPE_SECURITY (unless the user is in the DC admin group).

SAS Macros

• mpe_getvars.sas
• mpe_getgroups.sas
• mp_abort.sas
• mf_getuser.sas

Service Inputs

BROWSERPARAMS

The following variables MAY be provided from frontend (HIST can also be set in MPE_CONFIG):

• HIST - number of records to return
• STARTROW - the starting row (default is 1)

Service Outputs

FROMSAS

This table is returned, starting from &STARTROW for &HIST rows (ordered descending on SUBMITTED datetime)

• TABLE_ID
• BASE_TABLE
• SUBMITTED
• SUBMITTED_REASON_TXT
• SUBMITTER
• REVIEWED
• STATUS
• REVIEWED_ON_DTTM
• APPROVER

HISTPARAMS

• HIST - rows returned
• STARTROW - starting row used
• NOBS - Number of observations (rows) available

Version

9.3

Author

4GL Apps Ltd

Copyright

4GL Apps Ltd. This code may only be used within Data Controller and may not be re-distributed or re-sold without the express permission of 4GL Apps Ltd.

Definition in file gethistory.sas.