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 Name Field Type Column Type Description
    CLASSID Character(30) VARCHAR2(30) NOT NULL The name of the class (see PSCLASSDEFN).
    DAYOFWEEK Number(1,0) SMALLINT NOT NULL Day of Week
    DESCR Character(30) VARCHAR2(30) NOT NULL Description
    SIGNON_START_TIME Character(5) VARCHAR2(5) NOT NULL Start Time
    SIGNON_END_TIME Character(5) VARCHAR2(5) NOT NULL End Time
    index back (c)David Kurtz 2019, www.go-faster.co.uk PeopleTools 8.54
    PTRef generated on 09-JUN-19