Skip to content

Instantly share code, notes, and snippets.

View sukhsukhpinder's full-sized avatar

Sukhpinder Singh sukhsukhpinder

View GitHub Profile
{
"Version": "2012-10-17",
"Statement": [
{
"Effect": "Allow",
"Resource": [
"arn:aws:logs:us-west-2:350533793946:log-group:/aws/codebuild/ui-uat-codebuild",
"arn:aws:logs:us-west-2:350533793946:log-group:/aws/codebuild/ui-uat-codebuild:*"
],
"Action": [
exec usp_RPT_Performance_MVGains
@UserID=159,
@RptTemplateNameID=460,
@Indent=2,
@Annualized=1,
@ShowCashReturn=1,
@EndDate='2021-03-16',
@RptCurr='USD',
@NetGrossTotal=2,
@NetGrossSegments=1,
{
"Parent": "NULL",
"RowOrder": "1.00",
"Pad": "0",
"Indent": "0",
"ParentRptTempOrd": "NULL",
"RptTempOrd": "000460",
"RptPortID": "55464",
"RptTemplateNameID": "460",
"RptPortName": "Hafelfinger Family",
{
"RptTemplateNameDesc": "Capraro by Asset Class",
"RptTemplateNameIDTotal": "117",
"RptTemplateNameIDParts": "30"
}
exec [DD].[usp_Pivot_Perf_RptTemplateNameIDs]
@UserID=3
exec usp_RPT_IRR
@UserID=159,
@RptTemplateNameID=460,
@StartDate='2020-12-3',
@EndDate='2021-03-16',
@RptCurr=USD,
@Indent=2,
@ParentRptTempOrd ='',
@FocusRptTempOrd =''
{
"RowOrder": "2",
"Pad": "1",
"Indent": "1",
"RptPortID": "55464",
"RptPortfolioName": "Hafelfinger Family",
"RptTemplateNameID": "460",
"RptTemplateName": "By Asset Class/Sector",
"Parent": "000460",
"ParentRptTempOrd": "000460",
{
"1": "2.738100",
"2": "-0.940200",
"3": "1.772100",
"4": "NULL",
"5": "NULL",
"6": "NULL",
"7": "NULL",
"8": "NULL",
"9": "NULL",
exec usp_RPT_Performance_Periodic
@UserID=159,
@RptTemplateNameID=460,
@Indent=2,
@Annualized=1,
@ShowCashReturn=1,
@StartDate='2020-12-31',
@EndDate='2021-03-16',
@RptCurr='USD',
@periodicityID=3,
{
"RowOrder": "2",
"Pad": "1.00",
"Indent": "1",
"Parent": "000460",
"ParentRptTempOrd": "000460",
"RptTempOrd": "000460000001002021",
"OriginalRptTempOrd": "NULL",
"RptPortID": "55464",
"RptPortName": "Hafelfinger Family",