LM_ORG_VW2

(SQL View)
Index Back

Organization View

View selected fields of all Active, Current Organizations

SELECT LM_ORGANIZATION_ID , EFFDT , BUSINESS_UNIT_GL FROM PS_LM_ORGANIZATION WHERE %CurrentDateIn BETWEEN EFFDT AND LM_END_EFFDT AND EFF_STATUS = 'A'

# PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description
1 LM_ORGANIZATION_ID Number(15,0) DECIMAL(15) NOT NULL Organization ID
2 EFFDT Date(10) DATE Effective Date

Default Value: %date

3 BUSINESS_UNIT_GL Character(5) VARCHAR2(5) NOT NULL General Ledger Business Unit