SAD_PB_UPDSTVW

(SQL View)
Index Back

SELECT fieldvalue , effdt , eff_status , xlatlongname FROM PSXLATITEM WHERE fieldname='SAD_PB_UPDATE'

# PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description
1 SAD_PB_UPDATE Character(4) VARCHAR2(4) NOT NULL Update Status
DCMP=Update Complete
DRDY=Update Ready
DRQD=Update Required
2 EFFDT Date(10) DATE Effective Date

Default Value: %date

3 EFF_STATUS Character(1) VARCHAR2(1) NOT NULL Effective Status
A=Active
I=Inactive
4 XLATLONGNAME Character(30) VARCHAR2(30) NOT NULL Translate Long Name