PSSIGNON_VW

index back

Authorized Signon Period


SELECT B.CLASSID , B.DAYOFWEEK , A.XLATSHORTNAME , LPAD(TO_CHAR (FLOOR(STARTTIME/60)) ,2 , '0') ||':'|| LPAD(TO_CHAR (STARTTIME-(FLOOR(STARTTIME/60)*60)) ,2 , '0') , LPAD(TO_CHAR (FLOOR(ENDTIME/60)) ,2 , '0') ||':'|| LPAD(TO_CHAR (ENDTIME-(FLOOR(ENDTIME/60)*60)) ,2 , '0') FROM PSXLATITEM A , PSAUTHSIGNON B WHERE A.FIELDNAME='DAY_OFWEEK' AND A.FIELDVALUE=TO_CHAR(B.DAYOFWEEK)

  • Parent record: PSOPRDEFN
  • PeopleSoft Field NameField TypeColumn TypeDescription
    CLASSIDCharacter(30)VARCHAR2(30) NOT NULLThe name of the class (see PSCLASSDEFN).
    DAYOFWEEKNumber(1,0)SMALLINT NOT NULLDay of Week
    DESCRCharacter(30)VARCHAR2(30) NOT NULLDescription
    SIGNON_START_TIMECharacter(5)VARCHAR2(5) NOT NULLStart Time
    SIGNON_END_TIMECharacter(5)VARCHAR2(5) NOT NULLEnd Time
    index back(c)David Kurtz 2019, www.go-faster.co.ukPeopleTools 8.54
    PTRef generated on 09-JUN-19